Data Types
Supported Data Types
| Data Type | UI Symbol |
|---|---|
| BOOLEAN |  |
| VARBINARY |  |
| DATE |  |
| FLOAT |  |
| DECIMAL* |  |
| DOUBLE | |
| INTERVAL (day to seconds) |  |
| INTERVAL (years to months) | |
| INT |  |
| BIGINT | |
| TIME | |
| TIMESTAMP |  |
| VARCHAR** |  |
| MAP |  |
| LIST |  |
* Partially supported
** VARCHAR type only supports UTF-8 encoded values
Timestamp Queries
When Dremio retrieves the timestamp value entry in a table, the returned timestamp entry is displayed as it was written to the file system. That is, Dremio does not apply any conversions to the timestamp entry.
For example:
- If the timestamp value entry is written to the file system in UTC, then Dremio displays the entry in UTC.
- With Hive, all timestamp value entries are converted and stored as UTC in the file system.
Subsequently, when Dremio returns the timestamp value entry, it is displayed in UTC. - With some other application, if the timestamp value entry is written and stored as PST (local time) in the file system, then when Dremio returns the timestamp value entry, it is displayed in PST.
Source Data Type Mappings
The following topics provide Dremio data type mappings to source database types.