Oracle (ADBC) → Parquet
Datatypes conversion mapping when exporting from Oracle using the ADBC connector (--connectiontype adbc_oracle) to Parquet format.
Platform availability
The ADBC FastDriver connectors are available on Windows x64 and Linux x64 only. They are not supported on Linux ARM64.
info
The ADBC connector does not map every type the way the standard oraodp driver does. Compare both pages before switching.
| Source | Oracle (adbc_oracle) |
| Format | Parquet |
| FastBCP | 1.2.0.0 |
| Test Status | PARTIAL (21/25 Nullable) |
Failed Types
The following datatypes are not supported with this connector:
ROWID— export failsUROWID— export failsXMLTYPE— export failsBFILE— export fails
Parquet Schema: testdatatypes_nullable
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| COL_NUMBER | BYTE_ARRAY | UTF8 | StringType() |
| COL_NUMBER10 | INT64 | — | — |
| COL_NUMBER18_2 | FIXED_LEN_BYTE_ARRAY | DECIMAL | DecimalType(scale=2, precision=18) |
| COL_FLOAT | BYTE_ARRAY | UTF8 | StringType() |
| 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 | TimestampType(isAdjustedToUTC=0, unit=MILLIS) |
| COL_TIMESTAMP | INT64 | TIMESTAMP_MICROS | TimestampType(isAdjustedToUTC=0, unit=MICROS) |
| COL_TIMESTAMP_TZ | INT64 | TIMESTAMP_MICROS | TimestampType(isAdjustedToUTC=1, unit=MICROS) |
| COL_TIMESTAMP_LTZ | INT64 | TIMESTAMP_MICROS | TimestampType(isAdjustedToUTC=1, unit=MICROS) |
| COL_INTERVAL_YM | INT64 | — | — |
| COL_INTERVAL_DS | BYTE_ARRAY | UTF8 | StringType() |