Kafka target data types
The following table shows the default mapping from Qlik Replicate data types to Kafka 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.
When using the JSON message format, binary values are represented as hexadecimal digits.
Qlik Replicate Data Types | Kafka Target Data Types in Schema Messages |
---|---|
DATE |
DATE |
TIME |
TIME |
DATETIME |
DATETIME |
BYTES |
BYTES (length) |
BLOB |
BLOB |
REAL4 |
REAL4 (7) |
REAL8 |
REAL8 (14) |
INT1 |
INT1 (3) |
INT2 |
INT2 (5) |
INT4 |
INT4 (10) |
INT8 |
INT8 (19) |
UINT1 |
UINT1 (3) |
UINT2 |
UINT2 (5) |
UINT4 Information note
Values larger than 2^31-1 are not supported. |
UINT4 (10) |
UINT8 Information note
Values larger than 2^63-1 are not supported. |
UINT8 (20) |
NUMERIC |
NUMERIC (p,s) |
STRING |
STRING (Length) |
WSTRING |
STRING (Length) |
CLOB |
CLOB |
NCLOB |
NCLOB |
BOOLEAN |
BOOLEAN (1) |
Mapping to JSON and Avro
Avro message format uses logical types for a more precise representation of the data type.
Replicate data types will only be mapped to supported Avro logical data types if the Use logical data types for specific data types check box is selected.
Qlik Replicate Data Types | JSON or Avro Primitive Data Types (When not using logical data types) | 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 |
- |
WSTRING |
STRING |
- |
CLOB |
STRING |
- |
NCLOB |
STRING |
- |
NUMERIC |
STRING |
DECIMAL (p,s) Annotates an Avro BYTES. |
BYTES |
BYTES |
- |
BLOB |
BYTES |
- |
REAL4 |
FLOAT |
- |
REAL8 |
DOUBLE |
- |
INT1 |
INT |
- |
INT2 |
INT |
- |
INT4 |
INT |
- |
UINT1 |
INT |
- |
UINT2 |
INT |
- |
UINT4 |
LONG |
- |
INT8 |
LONG |
- |
UINT8 |
STRING |
DECIMAL (20,0) Annotates an Avro BYTES. |
BOOLEAN |
BOOLEAN |
- |