Skip to main 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.

Information note

When using the JSON message format, binary values are represented as hexadecimal digits.

Data type mappings
Qlik Replicate data types JSON Avro Logical data types

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

BYTES

BYTES

BLOB

BYTES

BYTES

REAL4

FLOAT

FLOAT

REAL8

DOUBLE

DOUBLE

INT1

INT

INT

INT2

INT

INT

INT4

INT

INT

UINT1

INT

INT

UINT2

INT

LONG

UINT4

LONG

LONG

INT8

LONG

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!