Data set	Event Count	Query Type	Time Taken (seconds)
Smart Home	10000000	`INSERT OVERWRITE TABLE cityUsage SELECT metro_area, avg(power_reading) AS avg_usage, min(power_reading) AS min_usage, max(power_reading) AS max_usage FROM smartHomeData GROUP BY metro_area`	26 sec
Smart Home	10000000	`INSERT OVERWRITE TABLE peakDeviceUsageRange SELECT house_id, (max(power_reading) - min(power_reading)) AS usage_range FROM smartHomeData WHERE is_peak = true AND metro_area = "Seattle" GROUP BY house_id`	22 sec
Smart Home	10000000	`INSERT OVERWRITE TABLE stateAvgUsage SELECT state, avg(power_reading) AS state_avg_usage FROM smartHomeData`	21 sec
Smart Home	10000000	`INSERT OVERWRITE TABLE stateUsageDifference SELECT a2.state, (a2.state_avg_usage-a1.overall_avg) AS avg_usage_difference FROM (select avg(state_avg_usage) as overall_avg from stateAvgUsage) as a1 join stateAvgUsage as a2`	`1 sec`
Wikipedia	10000000	`INSERT INTO TABLE wikiAvgArticleLength SELECT AVG(length) as avg_article_length FROM wiki`	48 min
Wikipedia	10000000	`INSERT INTO TABLE wikiContributorSummary SELECT contributor_username, COUNT(*) as page_count FROM wiki GROUP BY contributor_username`	1 hour 45 min
Wikipedia	10000000	`INSERT INTO TABLE wikiTotalArticleLength SELECT SUM(length) as total_article_chars FROM wiki`	44 min
Wikipedia	10000000	`INSERT INTO TABLE wikiTotalArticlePages SELECT COUNT(*) as total_pages FROM wiki`	1 hour 17 min

Retrieving Results

Scenario: Retrieving Process Monitoring Data via REST API

...