Skip to main content Skip to complementary content

Data types

The following table shows the default mapping from Qlik Replicate data types to Google Cloud Storage 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 and Google Cloud Storage data types
Qlik Replicatedata types Google Cloud Storage 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.

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!