hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Uma (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2704) Hive Hangs when I run SQL query with where clause
Date Tue, 10 Jan 2012 11:38:39 GMT
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

        

Mime
View raw message