hive真是慢

zhaopingzi

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

復(fù)制代碼