Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 99CB8B026 for ; Tue, 10 Jan 2012 11:58:53 +0000 (UTC) Received: (qmail 93836 invoked by uid 500); 10 Jan 2012 11:39:20 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 90871 invoked by uid 500); 10 Jan 2012 11:39:10 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 90809 invoked by uid 500); 10 Jan 2012 11:39:03 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 90788 invoked by uid 99); 10 Jan 2012 11:39:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jan 2012 11:39:00 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jan 2012 11:38:59 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 4D25D141C1B for ; Tue, 10 Jan 2012 11:38:39 +0000 (UTC) Date: Tue, 10 Jan 2012 11:38:39 +0000 (UTC) From: "Uma (Created) (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <118221687.25132.1326195519317.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Created] (HIVE-2704) Hive Hangs when I run SQL query with where clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 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= In order to limit the maximum number of reducers: set hive.exec.reducers.max= In order to set a constant number of reducers: set mapred.reduce.tasks= 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