Skip to main content Skip to complementary content

Supported data types

The table below shows the default mappings from Qlik Replicate data types to JSON and Avro logical data types.

For information on source data type mappings, see the section for the source endpoint you are using.

For additional information about Qlik Replicate data types, see Replicate data types.

Mapping to JSON and Avro

Avro message format uses logical types for a more precise representation of the data type.

Data type mappings
Qlik Replicate Data Types JSON Avro

DATE

STRING

DATE

Annotates an Avro INT.

TIME

STRING

TIME-MILLIS

Annotates an Avro INT.

TIMESTAMP

STRING

TIMESTAMP-MICROS

Annotates an Avro LONG.

STRING

STRING

STRING

WSTRING

STRING

STRING

CLOB

STRING

STRING

NCLOB

STRING

STRING

NUMERIC

STRING

DECIMAL (p,s)

Annotates an Avro BYTES.

BYTES

STRING (represented as hexadecimal digits)

BYTES

BLOB

STRING (represented as hexadecimal digits)

BYTES

REAL4

NUMBER

FLOAT

REAL8

NUMBER

DOUBLE

INT1

NUMBER

INT

INT2

NUMBER

INT

INT4

NUMBER

INT

INT8

NUMBER

LONG

UINT1

NUMBER

INT

UINT2

NUMBER

INT

UINT4

NUMBER

LONG

UINT8

STRING

DECIMAL (20,0)

Annotates an Avro BYTES.

BOOLEAN

BOOLEAN

BOOLEAN

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!