See all drill best practice FAQs.
DRILL supports two storage plugins that can be used for querying MAPR-DB tables.
a) DFS storage plugin.
b) HBASE storage plugin.
It is recommended that you use the DFS plugin to query MAPR-DB tables because it is well integrated with MAPR-DB and MAPR-FS.
The DFS storage plugin also supports the following optimizations, which are not available in the HBASE plugin.
1) Better predicate pushdown.
2) Better cardinality estimation.
3) Better support for reading JSON files.
Retrieving data ...