Hive to Drill Type Mapping
Using Drill you can read tables created in Hive that use data types in the Hive-to-Drill type mapping table. Currently, the Apache Hive version used by Drill does not support the timestamp in Unix Epoch format. The workaround is to use the JDBC format for the timestamp, which Hive accepts and Drill uses, as shown in the type mapping example.
For more information about connecting Drill to data sources, refer to Connect to Data Sources on the Apache Drill documentation web site. For information about workspaces, refer to Workspaces.