Striim 3.10.1 documentation

Parquet Formatter data type support and correspondence

The following apply when the input stream is of a user-defined type.

Striim type

Parquet type

Notes

Byte

INT32

DateTime

INT32

Unix epoch (number of days from 1 January 1970)

Double

DOUBLE

IEEE 64-bit

Float

FLOAT

IEEE 32-bit

Integer

INT32

32-bit signed

Long

INT64

64-bit signed

Short

INT32

String

BYTE_ARRAY

UTF-8

The following apply when the input stream is the output of a Database Reader or Incremental Batch Reader source.

JDBC column type

Parquet type

Notes

Types.BIGINT

INT32

32-bit signed

Types.BIT

INT32

Types.CHAR

BYTE_ARRAY

UTF-8

Types.DATE

INT32

Unix epoch (number of days from 1 January 1970)

Types.DECIMAL

BYTE_ARRAY

UTF-8

Types.DOUBLE

DOUBLE

IEEE 64-bit

Types.FLOAT

FLOAT

IEEE 32-bit

Types.INTEGER

INT32

32-bit signed

Types.NUMERIC

BYTE_ARRAY

UTF-8

Types.REAL

FLOAT

IEEE 32-bit

Types.SMALLINT

INT32

Unix epoch (number of days from 1 January 1970)

Types.TIMESTAMP

INT32

Types.TINYINT

INT32

Types.VARCHARCHAR

BYTE_ARRAY

UTF-8

other types

BYTE_ARRAY

UTF-8

The following apply when the input stream is the output of an Oracle Reader source.

Oracle type

Parquet type

ADT

unsupported

ARRAY

unsupported

BFILE

unsupported

BINARY_DOUBLE

DOUBLE

BINARY_FLOAT

FLOAT

BFILE

unsupported

BLOB

BYTE_ARRAY

CHAR

BYTE_ARRAY

CLOB

BYTE_ARRAY

DATE

BYTE_ARRAY

FLOAT

BYTE_ARRAY

INTERVALDAYTOSECOND

unsupported

INTERVALYEARTOMONTH

unsupported

LONG

unsupported

LONG RAW

unsupported

NCHAR

BYTE_ARRAY

NCLOB

BYTE_ARRAY

NESTED TABLE

unsupported

NUMBER

BYTE_ARRAY

NVARCHAR2

unsupported

RAW

unsupported

REF

unsupported

ROWID

unsupported

TIMESTAMP

BYTE_ARRAY

TIMESTAMP WITHLOCALTIMEZONE

BYTE_ARRAY

TIMESTAMP WITHTIMEZONE

BYTE_ARRAY

UDT

unsupported

UROWID

unsupported

VARCHAR2

BYTE_ARRAY

VARRAY

unsupported

XMLTYPE

unsupported