[
https://issues.apache.org/jira/browse/HIVE-2704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Capriolo resolved HIVE-2704.
-----------------------------------
Resolution: Won't Fix
Release Note: This is likely a set up issue.
> Hive Hangs when I run SQL query with where clause
> -------------------------------------------------
>
> Key: HIVE-2704
> URL: https://issues.apache.org/jira/browse/HIVE-2704
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.7.1
> Environment: Linux RedHat server
> Reporter: Uma
> Fix For: 0.7.1
>
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
