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 | timestamp |
| 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 |