Supported data types
The following table shows the supported data types and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source endpoint you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
Replicate data types | Databricks data types |
---|---|
BOOL |
BOOLEAN |
BYTES |
STRING |
TIME |
STRING |
DATETIME |
TIMESTAMP |
DATE |
DATE |
INT1 |
TINYINT |
INT2 |
SMALLINT |
INT4 |
INT |
INT8 |
BIGINT |
NUMERIC |
DECIMAL (p,s) |
REAL4 |
FLOAT |
REAL8 |
DOUBLE |
STRING |
Databricks 7.x and earlier: STRING Databricks 8.2 and later: VARCHAR (Length) |
UINT1 |
SMALLINT |
UINT2 |
INT |
UINT4 |
BIGINT |
UINT8 |
DECIMAL (20,0) |
WSTRING |
Databricks 7.x and earlier: STRING Databricks 8.2 and later: VARCHAR (Length) |
BLOB |
STRING |
NCLOB |
STRING |
CLOB |
STRING |
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) |