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