Skip to main content

Hadoop Endpoint target data types

The following table shows the Hadoop endpoint target data types that are supported when using Qlik Replicate 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 Replicatedata types Hadoop data types

BOOL

BOOLEAN

BYTES

STRING

TIME

STRING

DATETIME

TIMESTAMP

DATE

Note:

When Avro is selected as the Target storage format, the TIMESTAMP and DATE data types (which are not supported by Avro) are mapped to VARCHAR(37).

DATE

INT1

TINYINT

INT2

SMALLINT

INT4

INT

INT8

BIGINT

NUMERIC

DECIMAL (p,s)

REAL4

FLOAT

REAL8

DOUBLE

STRING

VARCHAR (Length)

UINT1

SMALLINT

UINT2

INT

UINT4

BIGINT

UINT8

DECIMAL (20,0)

WSTRING

VARCHAR (Length)

BLOB

STRING

NCLOB

STRING

CLOB

STRING