Details
Description
I have setup Hadoop hadoop-0.20.203.0 and hive-0.7.1 in Red Hat Enterprise Linux AS release 4 (Nahant Update 6)
In Hive when I fire a simple SQL query it gives resuult. whereas when I fire a query with where clause it hangs. I have tried even setting fairaScheduler. No luck. Please help me
hive> show tables;
OK
user_mstr
Time taken: 4.568 seconds
hive> select * from user_mstr;
OK
MGMT_VIEW,58,OPEN,04-JUN-12 NULL NULL NULL
SYS,0,OPEN,04-JUN-12 NULL NULL NULL
SYSTEM,5,OPEN,04-JUN-12 NULL NULL NULL
DBSNMP,29,OPEN,04-JUN-12 NULL NULL NULL
SYSMAN,56,OPEN,04-JUN-12 NULL NULL NULL
APPS,63,OPEN,05-JUN-12 NULL NULL NULL
OUTLN,9,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
FLOWS_FILES,59,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
MDSYS,54,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
ORDDATA,51,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
ORDSYS,50,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
ANONYMOUS,43,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
EXFSYS,41,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
WMSYS,31,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
XDB,42,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
APPQOSSYS,30,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
ORDPLUGINS,52,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
APEX_030200,62,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
SI_INFORMTN_SCHEMA,53,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
DIP,14,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
APEX_PUBLIC_USER,60,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
ORACLE_OCM,21,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
XS$NULL,2147483638,EXPIRED & LOCKED,07-DEC-11 NULL NULL NULL
Time taken: 0.738 seconds
hive> select username from user_mstr where status='OPEN';
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_201201101150_0001, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201201101150_0001
Kill Command = /home/dbcoe/apps/uma/hadoop/hadoop-0.20.203.0/bin/../bin/hadoop job -Dmapred.job.tracker=localhost:4004 -kill job_201201101150_0001
[dbcoe@pc-a400158 conf]$ hive
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Hive history file=/tmp/dbcoe/hive_job_log_dbcoe_201201101615_923409152.txt
hive> show tables;
OK
user_mstr
Time taken: 4.766 seconds
hive> select count(1) from user_mstr;
Total MapReduce jobs = 1
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 mapred.reduce.tasks=<number>
Starting Job = job_201201101150_0002, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201201101150_0002
Kill Command = /home/dbcoe/apps/uma/hadoop/hadoop-0.20.203.0/bin/../bin/hadoop job -Dmapred.job.tracker=localhost:4004 -kill job_201201101150_0002