hive的join实现

Time taken: 18.884 seconds, Fetched: 22 row(s)
hive> create table a(id int,name string)
    > row format delimited fields terminated by ',';
OK
Time taken: 0.098 seconds
hive> create table b(id int,name string)
    > row format delimited fields terminated by ',';
OK
Time taken: 0.11 seconds
hive> load data local inpath '/home/wangshumin/a' into table a;
Loading data to table hive2_db2.a
Table hive2_db2.a stats: [numFiles=1, totalSize=20]
OK
Time taken: 0.345 seconds
hive> load data local inpath '/home/wangshumin/b' into table b;
Loading data to table hive2_db2.b
Table hive2_db2.b stats: [numFiles=1, totalSize=20]
OK
Time taken: 0.256 seconds
hive> select  * from  a
    > select  * from  a;
FAILED: ParseException line 2:0 missing EOF at 'select' near 'a'
hive> select  *  from  a ;
OK
2 b
3 c
4 d
7 y
8 u
Time taken: 0.055 seconds, Fetched: 5 row(s)
hive> select  *  from  b ;
OK
2 bb
3 cc
7 yy
9 pp
Time taken: 0.061 seconds, Fetched: 4 row(s)
hive> select  a.* ,b.* from a inner join b on a.id=b.id;
Query ID = wangshumin_20180312223541_95b6facf-287c-4e4c-8a83-977bc560ef48
Total jobs = 1
18/03/12 22:35:44 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-35-41_401_7360788528790388546-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
18/03/12 22:35:44 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-35-41_401_7360788528790388546-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
Execution log at: /tmp/wangshumin/wangshumin_20180312223541_95b6facf-287c-4e4c-8a83-977bc560ef48.log
2018-03-12 22:35:44 Starting to launch local task to process map join; maximum memory = 518979584
2018-03-12 22:35:45 Dump the side-table for tag: 0 with group count: 5 into file: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-35-41_401_7360788528790388546-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile20--.hashtable
2018-03-12 22:35:45 Uploaded 1 File to: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-35-41_401_7360788528790388546-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile20--.hashtable (365 bytes)
2018-03-12 22:35:45 End of local task; Time Taken: 1.286 sec.
Execution completed successfully
MapredLocal task succeeded
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1520857876423_0019, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0019/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0019
Hadoop job information for Stage-3: number of mappers: 1; number of reducers: 0
2018-03-12 22:35:53,423 Stage-3 map = 0%,  reduce = 0%
2018-03-12 22:35:59,762 Stage-3 map = 100%,  reduce = 0%, Cumulative CPU 1.63 sec
MapReduce Total cumulative CPU time: 1 seconds 630 msec
Ended Job = job_1520857876423_0019
MapReduce Jobs Launched: 
Stage-Stage-3: Map: 1   Cumulative CPU: 1.63 sec   HDFS Read: 6227 HDFS Write: 27 SUCCESS
Total MapReduce CPU Time Spent: 1 seconds 630 msec
OK
2 b 2 bb
3 c 3 cc
7 y 7 yy
Time taken: 20.525 seconds, Fetched: 3 row(s)
hive> select * from a left join b on a.id=b.id;
Query ID = wangshumin_20180312223619_4ba45581-b66d-4ebb-9e91-389b47588d99
Total jobs = 1
18/03/12 22:36:22 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-36-19_596_5859123355450770291-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
18/03/12 22:36:22 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-36-19_596_5859123355450770291-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
Execution log at: /tmp/wangshumin/wangshumin_20180312223619_4ba45581-b66d-4ebb-9e91-389b47588d99.log
2018-03-12 22:36:22 Starting to launch local task to process map join; maximum memory = 518979584
2018-03-12 22:36:23 Dump the side-table for tag: 1 with group count: 4 into file: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-36-19_596_5859123355450770291-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile31--.hashtable
2018-03-12 22:36:23 Uploaded 1 File to: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-36-19_596_5859123355450770291-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile31--.hashtable (348 bytes)
2018-03-12 22:36:23 End of local task; Time Taken: 0.946 sec.
Execution completed successfully
MapredLocal task succeeded
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1520857876423_0020, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0020/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0020
Hadoop job information for Stage-3: number of mappers: 1; number of reducers: 0
2018-03-12 22:36:29,673 Stage-3 map = 0%,  reduce = 0%
2018-03-12 22:36:34,900 Stage-3 map = 100%,  reduce = 0%, Cumulative CPU 0.83 sec
MapReduce Total cumulative CPU time: 830 msec
Ended Job = job_1520857876423_0020
MapReduce Jobs Launched: 
Stage-Stage-3: Map: 1   Cumulative CPU: 0.83 sec   HDFS Read: 6200 HDFS Write: 47 SUCCESS
Total MapReduce CPU Time Spent: 830 msec
OK
2 b 2 bb
3 c 3 cc
4 d NULL NULL
7 y 7 yy
8 u NULL NULL
Time taken: 16.394 seconds, Fetched: 5 row(s)
hive> select * from a right join b on a.id=b.id;
Query ID = wangshumin_20180312223713_6f0ecb11-45f6-46c0-88ab-649b9c4aa3f2
Total jobs = 1
18/03/12 22:37:16 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-37-13_884_6215402660384412768-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
18/03/12 22:37:16 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-37-13_884_6215402660384412768-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
Execution log at: /tmp/wangshumin/wangshumin_20180312223713_6f0ecb11-45f6-46c0-88ab-649b9c4aa3f2.log
2018-03-12 22:37:16 Starting to launch local task to process map join; maximum memory = 518979584
2018-03-12 22:37:17 Dump the side-table for tag: 0 with group count: 5 into file: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-37-13_884_6215402660384412768-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile40--.hashtable
2018-03-12 22:37:17 Uploaded 1 File to: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-37-13_884_6215402660384412768-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile40--.hashtable (365 bytes)
2018-03-12 22:37:17 End of local task; Time Taken: 0.963 sec.
Execution completed successfully
MapredLocal task succeeded
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1520857876423_0021, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0021/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0021
Hadoop job information for Stage-3: number of mappers: 1; number of reducers: 0
2018-03-12 22:37:24,812 Stage-3 map = 0%,  reduce = 0%
2018-03-12 22:37:30,064 Stage-3 map = 100%,  reduce = 0%, Cumulative CPU 0.93 sec
MapReduce Total cumulative CPU time: 930 msec
Ended Job = job_1520857876423_0021
MapReduce Jobs Launched: 
Stage-Stage-3: Map: 1   Cumulative CPU: 0.93 sec   HDFS Read: 6200 HDFS Write: 38 SUCCESS
Total MapReduce CPU Time Spent: 930 msec
OK
2 b 2 bb
3 c 3 cc
7 y 7 yy
NULL NULL 9 pp
Time taken: 17.274 seconds, Fetched: 4 row(s)
hive> select * from a full outer join b on a.id=b.id;
Query ID = wangshumin_20180312223737_8e155f39-99ff-40ec-bcab-4ef493f09f1b
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks not specified. Defaulting to jobconf value of: 4
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
Starting Job = job_1520857876423_0022, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0022/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0022
Hadoop job information for Stage-1: number of mappers: 2; number of reducers: 4
2018-03-12 22:37:43,213 Stage-1 map = 0%,  reduce = 0%
2018-03-12 22:37:51,839 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 1.98 sec
2018-03-12 22:38:00,498 Stage-1 map = 100%,  reduce = 50%, Cumulative CPU 4.8 sec
2018-03-12 22:38:03,720 Stage-1 map = 100%,  reduce = 75%, Cumulative CPU 6.01 sec
2018-03-12 22:38:04,755 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 7.21 sec
MapReduce Total cumulative CPU time: 7 seconds 210 msec
Ended Job = job_1520857876423_0022
MapReduce Jobs Launched: 
Stage-Stage-1: Map: 2  Reduce: 4   Cumulative CPU: 7.21 sec   HDFS Read: 23216 HDFS Write: 58 SUCCESS
Total MapReduce CPU Time Spent: 7 seconds 210 msec
OK
4 d NULL NULL
8 u NULL NULL
NULL NULL 9 pp
2 b 2 bb
3 c 3 cc
7 y 7 yy
Time taken: 28.241 seconds, Fetched: 6 row(s)
hive> select * from a left semi join b on a.id = b.id;
Query ID = wangshumin_20180312224146_5fd8c66e-9d51-48cb-98c1-b6631fb690f2
Total jobs = 1
18/03/12 22:41:49 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-41-46_553_8842670393492493470-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
18/03/12 22:41:49 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-41-46_553_8842670393492493470-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
Execution log at: /tmp/wangshumin/wangshumin_20180312224146_5fd8c66e-9d51-48cb-98c1-b6631fb690f2.log
2018-03-12 22:41:49 Starting to launch local task to process map join; maximum memory = 518979584
2018-03-12 22:41:51 Dump the side-table for tag: 1 with group count: 4 into file: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-41-46_553_8842670393492493470-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile51--.hashtable
2018-03-12 22:41:51 Uploaded 1 File to: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-41-46_553_8842670393492493470-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile51--.hashtable (332 bytes)
2018-03-12 22:41:51 End of local task; Time Taken: 1.369 sec.
Execution completed successfully
MapredLocal task succeeded
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1520857876423_0023, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0023/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0023
Hadoop job information for Stage-3: number of mappers: 1; number of reducers: 0
2018-03-12 22:41:57,124 Stage-3 map = 0%,  reduce = 0%
2018-03-12 22:42:03,344 Stage-3 map = 100%,  reduce = 0%, Cumulative CPU 1.17 sec
MapReduce Total cumulative CPU time: 1 seconds 170 msec
Ended Job = job_1520857876423_0023
MapReduce Jobs Launched: 
Stage-Stage-3: Map: 1   Cumulative CPU: 1.17 sec   HDFS Read: 5922 HDFS Write: 12 SUCCESS
Total MapReduce CPU Time Spent: 1 seconds 170 msec
OK
2 b
3 c
7 y
Time taken: 17.875 seconds, Fetched: 3 row(s)
hive> select * from a where a.id exists(select b.id from b); 
FAILED: ParseException line 1:27 missing EOF at 'exists' near 'id'
hive> select * from a where a.id exists(select b.id from b); 
FAILED: ParseException line 1:27 missing EOF at 'exists' near 'id'
hive> select * from a left semi join b on a.id = b.id;
Query ID = wangshumin_20180312224718_3f2e4544-9b6a-4570-b24f-ae945f9548f9
Total jobs = 1
18/03/12 22:47:21 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-47-18_472_962974146787168225-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
18/03/12 22:47:21 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-47-18_472_962974146787168225-1/-local-10006/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
Execution log at: /tmp/wangshumin/wangshumin_20180312224718_3f2e4544-9b6a-4570-b24f-ae945f9548f9.log
2018-03-12 22:47:21 Starting to launch local task to process map join; maximum memory = 518979584
2018-03-12 22:47:22 Dump the side-table for tag: 1 with group count: 4 into file: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-47-18_472_962974146787168225-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile61--.hashtable
2018-03-12 22:47:22 Uploaded 1 File to: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-47-18_472_962974146787168225-1/-local-10003/HashTable-Stage-3/MapJoin-mapfile61--.hashtable (332 bytes)
2018-03-12 22:47:22 End of local task; Time Taken: 1.272 sec.
Execution completed successfully
MapredLocal task succeeded
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1520857876423_0024, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0024/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0024
Hadoop job information for Stage-3: number of mappers: 1; number of reducers: 0
2018-03-12 22:47:29,853 Stage-3 map = 0%,  reduce = 0%
2018-03-12 22:47:36,099 Stage-3 map = 100%,  reduce = 0%, Cumulative CPU 1.17 sec
MapReduce Total cumulative CPU time: 1 seconds 170 msec
Ended Job = job_1520857876423_0024
MapReduce Jobs Launched: 
Stage-Stage-3: Map: 1   Cumulative CPU: 1.17 sec   HDFS Read: 5916 HDFS Write: 12 SUCCESS
Total MapReduce CPU Time Spent: 1 seconds 170 msec
OK
2 b
3 c
7 y
Time taken: 18.704 seconds, Fetched: 3 row(s)
hive> select * from a left semi join b on a.id = b.id order by  id ;
Query ID = wangshumin_20180312224811_67c3057e-5caf-4c9a-af3b-317b761ddad1
Total jobs = 1
18/03/12 22:48:14 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-11_404_4539599114018466948-1/-local-10007/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
18/03/12 22:48:14 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-11_404_4539599114018466948-1/-local-10007/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
Execution log at: /tmp/wangshumin/wangshumin_20180312224811_67c3057e-5caf-4c9a-af3b-317b761ddad1.log
2018-03-12 22:48:14 Starting to launch local task to process map join; maximum memory = 518979584
2018-03-12 22:48:15 Dump the side-table for tag: 1 with group count: 4 into file: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-11_404_4539599114018466948-1/-local-10004/HashTable-Stage-2/MapJoin-mapfile71--.hashtable
2018-03-12 22:48:15 Uploaded 1 File to: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-11_404_4539599114018466948-1/-local-10004/HashTable-Stage-2/MapJoin-mapfile71--.hashtable (332 bytes)
2018-03-12 22:48:15 End of local task; Time Taken: 1.256 sec.
Execution completed successfully
MapredLocal task succeeded
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
Starting Job = job_1520857876423_0025, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0025/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0025
Hadoop job information for Stage-2: number of mappers: 1; number of reducers: 1
2018-03-12 22:48:22,617 Stage-2 map = 0%,  reduce = 0%
2018-03-12 22:48:27,878 Stage-2 map = 100%,  reduce = 0%, Cumulative CPU 1.45 sec
2018-03-12 22:48:34,095 Stage-2 map = 100%,  reduce = 100%, Cumulative CPU 2.5 sec
MapReduce Total cumulative CPU time: 2 seconds 500 msec
Ended Job = job_1520857876423_0025
MapReduce Jobs Launched: 
Stage-Stage-2: Map: 1  Reduce: 1   Cumulative CPU: 2.5 sec   HDFS Read: 9963 HDFS Write: 12 SUCCESS
Total MapReduce CPU Time Spent: 2 seconds 500 msec
OK
2 b
3 c
7 y
Time taken: 23.773 seconds, Fetched: 3 row(s)
hive> select * from a left semi join b on a.id = b.id order by  id desc;
Query ID = wangshumin_20180312224842_727cd879-7684-4db3-b0d6-0d2294293ea3
Total jobs = 1
18/03/12 22:48:45 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-42_918_6409153169399790807-1/-local-10007/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
18/03/12 22:48:45 WARN conf.Configuration: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-42_918_6409153169399790807-1/-local-10007/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
Execution log at: /tmp/wangshumin/wangshumin_20180312224842_727cd879-7684-4db3-b0d6-0d2294293ea3.log
2018-03-12 22:48:46 Starting to launch local task to process map join; maximum memory = 518979584
2018-03-12 22:48:47 Dump the side-table for tag: 1 with group count: 4 into file: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-42_918_6409153169399790807-1/-local-10004/HashTable-Stage-2/MapJoin-mapfile81--.hashtable
2018-03-12 22:48:47 Uploaded 1 File to: file:/tmp/wangshumin/d34feb44-cea8-41c7-895e-8d45cf04e3a4/hive_2018-03-12_22-48-42_918_6409153169399790807-1/-local-10004/HashTable-Stage-2/MapJoin-mapfile81--.hashtable (332 bytes)
2018-03-12 22:48:47 End of local task; Time Taken: 1.505 sec.
Execution completed successfully
MapredLocal task succeeded
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
Starting Job = job_1520857876423_0026, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1520857876423_0026/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1520857876423_0026
Hadoop job information for Stage-2: number of mappers: 1; number of reducers: 1
2018-03-12 22:48:53,667 Stage-2 map = 0%,  reduce = 0%
2018-03-12 22:48:59,909 Stage-2 map = 100%,  reduce = 0%, Cumulative CPU 1.49 sec
2018-03-12 22:49:05,093 Stage-2 map = 100%,  reduce = 100%, Cumulative CPU 2.46 sec
MapReduce Total cumulative CPU time: 2 seconds 460 msec
Ended Job = job_1520857876423_0026
MapReduce Jobs Launched: 
Stage-Stage-2: Map: 1  Reduce: 1   Cumulative CPU: 2.46 sec   HDFS Read: 9963 HDFS Write: 12 SUCCESS
Total MapReduce CPU Time Spent: 2 seconds 460 msec
OK
7 y
3 c
2 b
Time taken: 23.292 seconds, Fetched: 3 row(s)
hive>