Apache Drill can connect to data in a range of different types of data sources. For specific information about what types of data and data sources are supported, and how that data is handled, see the official documentation from Apache Drill.
SQL Data type in Apache Drill or Dremio |
Supported |
BIGINT |
Yes |
BINARY |
Yes |
BOOLEAN |
Yes |
DATE |
Yes |
DECIMAL |
Yes |
DOUBLE |
Yes |
FLOAT |
Yes |
INTEGER |
Yes |
TIME |
Yes |
TIMESTAMP |
Yes |
VARCHAR |
Yes |
INTERVAL |
No |
See also:
Accessing Data from Apache Drill and Dremio
Using DSNs to Create Connections to Apache Drill and Dremio
How to use a DSN to create a connection to Apache Drill or Dremio