Drill provides intuitive and familiar semantics to perform self-service data exploration. Here is a quick look at a Drill query.
All you need is to write regular ANSI SQL queries, and point to the right location of the data source. Drill takes care of the rest for you - no schema definitions or complex ETL required.
Here are some examples of Drill queries:
SELECT errorLevel, count(*) FROM dfs.logs.`/AppServerLogs` GROUP BY errorLevel;Querying an Hbase table without creating any Hive metastore entries
SELECT cf1.month, cf1.year FROM hbase.table1;Querying nested data within an HBase table
SELECT profile.name, profile.children FROM ( SELECT CONVERT_FROM(cf1.profileBlob, 'json') AS profile FROM hbase.users )
Click here to run Drill queries all by yourself in less than 10 mins.