Oracle Data Types
Dremio supports selecting the following Oracle Database types. The following table shows the mappings from Oracle to Dremio data types.
[info] Note: If a type is not present in the table, it is not currently supported.
Oracle Database Type | Dremio Type |
---|---|
BINARY_DOUBLE | double |
BINARY_FLOAT | float |
DATE | date |
FLOAT | double |
INTERVALDS | integer (day to seconds) |
INTERVALYM | integer (years to months) |
LONG RAW | varbinary |
LONG | varchar |
NCHAR | varchar |
NUMBER | double |
NVARCHAR2 | varchar |
RAW | varbinary |
TIMESTAMP | timestamp |
VARCHAR2 | varchar |