You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Uma (Created) (JIRA)" <ji...@apache.org> on 2012/01/10 12:38:39 UTC
[jira] [Created] (HIVE-2704) Hive Hangs when I run SQL query with
where clause
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
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
[jira] [Resolved] (HIVE-2704) Hive Hangs when I run SQL query with
where clause
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ 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