Data types
The following table shows the default mapping from Qlik Replicate data types to Microsoft Azure ADLS target data types. Note that the data type mapping is only relevant if the Create metadata files in the target folder option is enabled.
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.
| Qlik Replicate Data Types | Microsoft Azure ADLS Target Data Types |
|---|---|
|
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 |
UINT4 (10) |
|
UINT8 |
UINT8 (20) |
|
NUMERIC |
NUMERIC (p,s) |
|
STRING |
STRING (Length) |
|
WSTRING |
STRING (Length) |
|
CLOB |
CLOB |
|
NCLOB |
NCLOB |
|
BOOLEAN |
BOOLEAN (1) |
Mapping from Qlik Replicate data types to Parquet
When Parquet is set as the message format, due to the limited number of data types supported by Parquet, the data type mappings will be as shown in the table below.
| Replicate Data Type | Parquet Primitive Type | Logical Type |
|---|---|---|
|
BOOLEAN |
BOOLEAN |
|
|
INT1 |
INT32 |
INT(8, true) |
|
INT2 |
INT32 |
INT(16, true) |
|
INT4 |
INT32 |
|
|
INT8 |
INT64 |
|
|
UINT1 |
INT32 |
INT(8, false) |
|
UINT2 |
INT32 |
INT(16, false) |
|
UINT4 |
INT64 |
|
|
UINT8 |
INT64 |
INT(64, false) |
|
REAL4 |
FLOAT |
|
|
REAL8 |
DOUBLE |
|
|
NUMERIC |
FIXED_LEN_BYTE_ARRAY (16) |
DECIMAL (precision, scale) |
|
STRING |
BYTE_ARRAY |
STRING |
|
WSTRING |
BYTE_ARRAY |
STRING |
|
BYTES |
BYTE_ARRAY |
|
|
BLOB |
BYTE_ARRAY |
|
|
CLOB |
BYTE_ARRAY |
STRING |
|
NCLOB |
BYTE_ARRAY |
STRING |
|
DATE |
INT32 |
DATE |
|
TIME |
INT32 |
TIME(UTC=true, unit=MILLIS) |
|
DATETIME |
INT64 |
TIMESTAMP(UTC=true, unit=MICROS) |