Oracle → Parquet

Datatypes conversion mapping when exporting from Oracle (--connectiontype oracle) to Parquet format.

Source	Oracle (oraodp)
Format	Parquet
FastBCP	0.32.2.0
Test Status	PASS (Nullable)

Parquet Schema: testdatatypes_nullable

name	physical_type	converted_type	logical_type
COL_NUMBER	FIXED_LEN_BYTE_ARRAY	DECIMAL	DecimalType(scale=18, precision=38)
COL_NUMBER10	INT64	INT_64	IntType(bitWidth=64, isSigned=1)
COL_NUMBER18_2	INT64	DECIMAL	DecimalType(scale=2, precision=18)
COL_FLOAT	FIXED_LEN_BYTE_ARRAY	DECIMAL	DecimalType(scale=18, precision=38)
COL_BINARY_FLOAT	FLOAT	—	—
COL_BINARY_DOUBLE	DOUBLE	—	—
COL_CHAR	BYTE_ARRAY	UTF8	StringType()
COL_VARCHAR2	BYTE_ARRAY	UTF8	StringType()
COL_NCHAR	BYTE_ARRAY	UTF8	StringType()
COL_NVARCHAR2	BYTE_ARRAY	UTF8	StringType()
COL_CLOB	BYTE_ARRAY	UTF8	StringType()
COL_NCLOB	BYTE_ARRAY	UTF8	StringType()
COL_BLOB	BYTE_ARRAY	—	—
COL_RAW	BYTE_ARRAY	—	—
COL_LONG_RAW	BYTE_ARRAY	—	—
COL_DATE	INT64	TIMESTAMP_MILLIS	—
COL_TIMESTAMP	INT64	TIMESTAMP_MILLIS	—
COL_TIMESTAMP_TZ	BYTE_ARRAY	UTF8	StringType()
COL_TIMESTAMP_LTZ	INT64	TIMESTAMP_MILLIS	—
COL_INTERVAL_YM	INT64	INT_64	IntType(bitWidth=64, isSigned=1)
COL_INTERVAL_DS	BYTE_ARRAY	UTF8	StringType()
COL_ROWID	BYTE_ARRAY	UTF8	StringType()
COL_UROWID	BYTE_ARRAY	UTF8	StringType()
COL_XMLTYPE	BYTE_ARRAY	UTF8	StringType()
COL_BFILE	BYTE_ARRAY	—	—