hive真是慢
hive> select * from pokes;
OK
1 redtao
3 blacktao
4 fangk
Time taken: 9.728 seconds, Fetched: 3 row(s)
hive>
hive> select * from pokes where foo=3;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201312091541_0020, Tracking URL = http://mysql3:50030/jobdetails.jsp?jobid=job_201312091541_0020
Kill Command = /home/hadoop/hadoop/libexec/../bin/hadoop job-kill job_201312091541_0020
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2013-12-17 14:21:52,964 Stage-1 map = 0%,reduce = 0%
2013-12-17 14:22:00,063 Stage-1 map = 100%,reduce = 0%, Cumulative CPU 1.59 sec
2013-12-17 14:22:01,279 Stage-1 map = 100%,reduce = 0%, Cumulative CPU 1.59 sec
2013-12-17 14:22:02,376 Stage-1 map = 100%,reduce = 0%, Cumulative CPU 1.59 sec
2013-12-17 14:22:03,631 Stage-1 map = 100%,reduce = 0%, Cumulative CPU 1.59 sec
2013-12-17 14:22:05,571 Stage-1 map = 100%,reduce = 0%, Cumulative CPU 1.59 sec
MapReduce Total cumulative CPU time: 1 seconds 590 msec
Ended Job = job_201312091541_0020
MapReduce Jobs Launched:
Job 0: Map: 1 Cumulative CPU: 1.59 sec HDFS Read: 235 HDFS Write: 11 SUCCESS
Total MapReduce CPU Time Spent: 1 seconds 590 msec
OK
3 blacktao
Time taken: 84.645 seconds, Fetched: 1 row(s)
hive>
页:
[1]