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 (NotNull + Nullable) |
Parquet Schema: testdatatypes_notnull
| 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 | — | — |
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 | — | — |