User Guide

1.1
- 1.3
- 1.2
- 1.0

Back Next

Avro Fields That Define a Source Column

In an Avro flat or nested schema, the following four fields define each source column:

Column definition:

{"name" : "COL1", "type" : [ "null", "string" ], "doc" : "...", "default" : null}

Column value is-present indicator:

{"name" : "COL1_Present", "type" : "boolean", "doc" : "Contains true when the value of field COL1 is present in the change data stream", "default" : false}

Column before image:

{"name" : "COL1_BeforeImage", "type" : [ "null", "string" ],"doc" : "Contains the before image of field COL1", "default" : null}

Column before image is-present indicator:

{"name" : "COL1_BeforeImage_Present", "type" : "boolean", "doc" : "Contains true when the value of field COL1_OLD is present.", "default" : false}

For example, two columns named "COL1" and "COL2" have the following Avro definitions:

{"name" : "COL1", "type" : [ "null", "string" ], "doc" : "...", "default" : null}
{"name" : "COL1_Present", "type" : "boolean", "doc" : …}
{"name" : "COL1_BeforeImage", "type" : [ "null", "string" ],"doc" : … }
{"name" : "COL1_BeforeImage_Present", "type" : "boolean", "doc" : …}

{"name" : "COL2", "type" : [ "null", "string" ], "doc" : "...", "default" : null}
{"name" : "COL2_Present", "type" : "boolean", "doc" : …}
{"name" : "COL2_BeforeImage", "type" : [ "null", "string" ],"doc" : … }
{"name" : "COL2_BeforeImage_Present", "type" : "boolean", "doc" : …}

Rename Saved Search

Table of Contents

User Guide

User Guide

Avro Fields That Define a Source Column

Avro Fields That Define a Source Column