hive (wmf)> select wiki_db, min(count), max(count), avg(count) from (select wiki_db, event_date, count(1) as count from (select wiki_db, substr(event_timestamp, 1, 8) as event_date from mediawiki_history where snapshot='2017
-04' and cast(substr(event_timestamp, 1, 8) as int) > 20170000) x group by wiki_db, event_date) y group by wiki_db;
Query ID = ebernhardson_20170504212525_47844c90-642f-451c-89b9-09b41f9fb5a3
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks not specified. Estimated from input data size: 718
In order to change the average load for a reducer (in bytes):