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.


results matching ""

    No results matching ""