Apache Drill Setup and Usuage

Apache Drill Setup and Usuage:
Install and Configure Apache Drill

http://drill.apache.org/docs/installing-drill-on-windows/

sqlline> !connect “jdbc:drill:zk=local”
Enter username for jdbc:drill:zk=local: admin
Enter password for jdbc:drill:zk=local: *****

http://localhost:8047/

SELECT derivedtable.ItemID ,AVG( CAST (derivedtable.TimeSpent AS INTEGER)) AvgTimeSpent
FROM
( SELECT rawresponsetime.Time10.id ItemID ,rawresponsetime.Time10.value TimeSpent FROM ( SELECT (flatten(time)) Time10,
* FROM RawResponse.default.C:\Dev\Tools\Drill\Data\RawResponse.json limit 10000
) rawresponsetime
) derivedtable
GROUP BY derivedtable.ItemID
ORDER BY ItemID