Hive
  1. Hive
  2. HIVE-2704

Hive Hangs when I run SQL query with where clause

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 0.7.1
    • Fix Version/s: 0.7.1
    • Component/s: SQL
    • Labels:
      None
    • Environment:

      Linux RedHat server

    • Release Note:
      This is likely a set up issue.

      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

        Activity

        Uma created issue -
        Edward Capriolo made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Release Note This is likely a set up issue.
        Resolution Won't Fix [ 2 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Uma
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 48h
              48h
              Remaining:
              Remaining Estimate - 48h
              48h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Development