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.

Qlik Replicate and Databricks on AWS 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.

Parquet data type mappings
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	FIXED_LEN_BYTE_ARRAY ($LENGTH)
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)

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!

Leave your feedback here