Supported data types
The following table shows the default mapping from Qlik Cloud data types to Amazon S3 target data types. Note that the data type mapping is only relevant if the Create metadata files in the target folder option in the "Land data in data lake" task settings is enabled.
| Qlik Cloud Data Types | Amazon S3 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 Cloud 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.
| Qlik Cloud 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) |