DBMS_CLOUD Package Parquet to Oracle Data Type Mapping
Describes the mapping of Parquet data types to Oracle data types.
Note
Complex types, such as maps, arrays, and structs are supported starting with Oracle Database 19c. See DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types for information on using Parquet complex types.
Complex types, such as maps, arrays, and structs are supported starting with Oracle Database 19c. See DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types for information on using Parquet complex types.
| Parquet Type | Oracle Type |
|---|---|
| UINT_64 | NUMBER(20) |
| INT_64 | NUMBER(19) |
| UINT_32 | NUMBER(10) |
| INT_32 | NUMBER(10) |
| UINT_16 | NUMBER(5) |
| INT_16 | NUMBER(5) |
| UINT_8 | NUMBER(3) |
| INT_8 | NUMBER(3) |
| BOOL | NUMBER(1) |
| UTF8 BYTE_ARRAY | VARCHAR2(4000 BYTE) |
| FLT | BINARY_FLOAT |
| DBL | BINARY_DOUBLE |
| DECIMAL(p) | NUMBER(p) |
| DECIMAL(p,s) | NUMBER(p,s) |
| DATE | DATE |
| STRING | VARCHAR2(4000) |
| TIME_MILLIS | VARCHAR2(20 BYTE) |
| TIME_MILLIS_UTC | VARCHAR2(20 BYTE) |
| TIME_MICROS | VARCHAR2(20 BYTE) |
| TIME_MICROS_UTC | VARCHAR2(20 BYTE) |
| TIMESTAMP_MILLIS | TIMESTAMP(3) |
| TIMESTAMP_MILLIS_UTC | TIMESTAMP(3) |
| TIMESTAMP_MICROS | TIMESTAMP(6) |
| TIMESTAMP_MICROS_UTC | TIMESTAMP(6) |
| TIMESTAMP_NANOS | TIMESTAMP(9) |
See DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types for information on using Parquet complex types.
Parent topic: DBMS_CLOUD Avro, ORC, and Parquet Support