User Guide

1.0
- 1.3
- 1.2
- 1.1

Back Next

Avro Nested Schema Format

An Avro schema that uses the nested format has a main Avro record that contains a separate nested record for each type of Avro column-definition field. The schema is specific to the source object that contains the defined columns.

The following nested schema defines two columns in four records:

{“name” : “columns“ , “type" : "record", fields" : [ {
   {"name" : "COL1", "type" : [ "null", "string" ], "doc" : "...", "default" : null}
   {"name" : "COL2", "type" : [ "null", "string" ], "doc" : "...", "default" : null}}] 
{“name” : “isPresent“ , “type" : "record", fields" : [ {
   {"name" : "COL1_Present", "type" : "boolean", "doc" : …}
   {"name" : "COL2_Present", "type" : "boolean", "doc" : …} }]
{“name” : “beforeImageValues“ , “type" : "record", fields" : [ {
   {"name" : "COL1_BeforeImage", "type" : [ "null", "string" ],"doc" : … }
   {"name" : "COL2_BeforeImage", "type" : [ "null", "string" ],"doc" : … } }]
{“name” : “isPresentIndicatorsForBeforeImages“ , “type" : "record", fields" : [ {
   {"name" : "COL1_BeforeImage_Present", "type" : "boolean", "doc" : …}

Rename Saved Search

Table of Contents

User Guide

User Guide

Avro Nested Schema Format

Avro Nested Schema Format