背景:学习大数据,装了个虚拟机,搭载centos7的迷你,内存分配的512MB
hive> select A.name,A.time> from
> (select name,time,sum(count) from sale group by name, time) A join
> (select name,time,sum(count) from sale group by name, time) B
> on A.name=B.name
> where A.time >= B.time
> group by A.name,A.time
> order by A.name,A.time;
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Query ID = root_20170227013835_5b837518-4c01-4dd5-8097-99d9dfdd39d7
Total jobs = 7
Launching Job 1 out of 7
Number of reduce tasks not specified. Estimated from input data size: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=