Drill Storage and Format Plugin Support Matrix

You can deploy Drill without Hadoop in a standalone configuration on a single node, however multi-node standalone cluster deployments of Drill are not supported. Note that Drill itself does not require Hadoop.

The following table lists the supported and unsupported data sources and formats in Drill:

Data Source Storage Plugin Type Formats Supported
file system dfs Text (CSV, TSV, PSV) Yes
Parquet Yes
JSON Yes
Avro No
HPE Ezmeral Data Fabric Database dfs Binary Yes
JSON Yes
HBase hbase Binary Yes
Hive hive Text (CSV, TSV, PSV) Yes
Parquet Yes
JSON Yes
Avro Yes
Other Hive built-in SerDes Yes (Not recommended due to the memory overhead and performance implications.)
S3 s3 Supports the same formats as the dfs storage plugin. Yes
MongoDB mongodb N/A No
RDBMS jdbc N/A No
Kudu kudu N/A No
Kafka kafka JSON Yes
OpenTSDB openTSDB N/A
NOTE
The openTSDB storage plugin is not officially supported. See OpenTSDB Storage Plugin for more information.