Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6B8F410995 for ; Mon, 26 Aug 2013 16:42:35 +0000 (UTC) Received: (qmail 31152 invoked by uid 500); 26 Aug 2013 16:42:26 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 31040 invoked by uid 500); 26 Aug 2013 16:42:23 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 30890 invoked by uid 99); 26 Aug 2013 16:42:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Aug 2013 16:42:19 +0000 X-ASF-Spam-Status: No, hits=1.8 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of nitinpawar432@gmail.com designates 209.85.216.177 as permitted sender) Received: from [209.85.216.177] (HELO mail-qc0-f177.google.com) (209.85.216.177) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Aug 2013 16:42:14 +0000 Received: by mail-qc0-f177.google.com with SMTP id e1so210505qcx.22 for ; Mon, 26 Aug 2013 09:41:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=DZ8Dud/Y8GB+256Ed65DPMgoHksDjl4trjFd8/t25sc=; b=ffB1c/jmqwKiDtEMvaZOgZC8WYCENNnWgaWEWVTOoSqJIvab+Gw6eaoTF/p1xVNmO1 dbNNDv//kh/zVsNVB/3rctw1JRPmjWQBZ+DeTTMNghAuPocb3XSKGI+R3I5sfDHIxJHP Q8dnikNViNEh4r4uoHzkOV8eYYBXi0U6whprw0/4jaec6Y0eHfqTIbpmkv8PjDPqobyp XpRsaLOlbjzF7Qst3Tw65mfpqUk5rsFBw/BbIsp4FM6vjVRl45hRNt9lBVDxd9flEODA qPs6QhXNGX1ADnUNqDmn+afPW+1m9umSzUj//lb2HGf9la9pwCXYW59Nym/8o7GGwSa5 4C3Q== MIME-Version: 1.0 X-Received: by 10.49.82.43 with SMTP id f11mr18373559qey.26.1377535313196; Mon, 26 Aug 2013 09:41:53 -0700 (PDT) Received: by 10.224.202.197 with HTTP; Mon, 26 Aug 2013 09:41:53 -0700 (PDT) In-Reply-To: References: Date: Mon, 26 Aug 2013 22:11:53 +0530 Message-ID: Subject: Re: [HIVE] Cannot perform a queries From: Nitin Pawar To: "user@hive.apache.org" Content-Type: multipart/alternative; boundary=047d7b621fb2023c2c04e4dc6fd6 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b621fb2023c2c04e4dc6fd6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Can you share your hive-site.xml and zookeeper log? Unless you are using concurrency in hive, zookeeper is not needed. I run hive without zookeeper. On Mon, Aug 26, 2013 at 9:38 PM, Guillermo Alvarado < guillermoalvarado89@gmail.com> wrote: > Hi, > > Anybody can give me some help with this please? > > Thanks in advance, > Regards. > > > 2013/8/22 Guillermo Alvarado > >> Hi everyone, >> >> I have a CDH4 cluster running In 4 nodes. I can perform queries in >> Beeswax UI but If I try to perform the same query with the hive console = it >> is not possible. >> >> I launched the console in this way: hive -hiveconf >> hive.root.logger=3DDEBUG,console and this is the output. >> >> =3D=3D=3D=3D=3D >> >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client >> environment:java.library.path=3D/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3= .0.p0.22/lib/hadoop/lib/native >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client >> environment:java.io.tmpdir=3D/tmp >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client >> environment:java.compiler=3D >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:os.name >> =3DLinux >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client >> environment:os.arch=3Damd64 >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client >> environment:os.version=3D2.6.32-279.el6.x86_64 >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:user.name >> =3Droot >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client >> environment:user.home=3D/root >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:user.dir= =3D/ >> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Initiating client connection= , >> connectString=3Ddatlas-cloudera-m01:2181 sessionTimeout=3D600000 >> watcher=3Dorg.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockM= anager$DummyWatcher@357c7988 >> 13/08/22 13:44:21 DEBUG zookeeper.ClientCnxn: >> zookeeper.disableAutoWatchReset is false >> 13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Opening socket connection t= o >> server datlas-cloudera-m01/10.5.96.195:2181. Will not attempt to >> authenticate using SASL (No se puede localizar una configuraci=F3n de in= icio >> de sesi=F3n) >> 13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Socket connection >> established to datlas-cloudera-m01/10.5.96.195:2181, initiating session >> 13/08/22 13:44:21 DEBUG zookeeper.ClientCnxn: Session establishment >> request sent on datlas-cloudera-m01/10.5.96.195:2181 >> 13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Unable to read additional >> data from server sessionid 0x0, likely server has closed socket, closing >> socket connection and attempting reconnect >> Interrupting... Be patient, this might take some time. >> 13/08/22 13:44:21 INFO CliDriver: Interrupting... Be patient, this might >> take some time. >> 13/08/22 13:44:21 INFO ql.Driver: >> 13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Opening socket connection t= o >> server datlas-cloudera-m01/10.5.96.195:2181. Will not attempt to >> authenticate using SASL (No se puede localizar una configuraci=F3n de in= icio >> de sesi=F3n) >> 13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Socket connection >> established to datlas-cloudera-m01/10.5.96.195:2181, initiating session >> 13/08/22 13:44:22 DEBUG zookeeper.ClientCnxn: Session establishment >> request sent on datlas-cloudera-m01/10.5.96.195:2181 >> 13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Unable to read additional >> data from server sessionid 0x0, likely server has closed socket, closing >> socket connection and attempting reconnect >> >> =3D=3D=3D=3D=3D=3D >> >> Also, when I see the status of the services with the cloudera manager UI >> I see a Bad Health in Zookeper and HBase. I restarted a lot of times >> Zookeper but it is in the same status. >> >> Why I can perform queries with Beeswax UI and not with Hive console? And >> how can I solve this problem? >> >> BTW, if I type SHOW TABLES, I get the result, but a SELECT does not work >> >> >> I will apreciate very much your help, >> Thanks in advance. >> > > --=20 Nitin Pawar --047d7b621fb2023c2c04e4dc6fd6 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Can you share your hive-site.xml =A0and zookeeper log?=A0<= div>Unless you are using concurrency in hive, zookeeper is not needed.=A0

I run hive without zookeeper.=A0


On Mon, Aug 26, 2013 at 9:38 PM, Guiller= mo Alvarado <guillermoalvarado89@gmail.com> wrot= e:
Hi,

Anyb= ody can give me some help with this please?

Thanks= in advance,
Regards.


2013/8/22 Guillermo Alv= arado <guillermoalvarado89@gmail.com>
Hi everyone,

I have a CDH4 cluster running In 4 nodes. I can perform que= ries in Beeswax UI but If I try to perform the same query with the hive con= sole it is not possible.=A0

I launched the console in this way: hive -hiveconf hive= .root.logger=3DDEBUG,console and this is the output.

=3D=3D=3D=3D=3D

13/08/22 13:44:21 INFO zoo= keeper.ZooKeeper: Client environment:java.library.path=3D/opt/cloudera/parc= els/CDH-4.3.0-1.cdh4.3.0.p0.22/lib/hadoop/lib/native
13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:java.io= .tmpdir=3D/tmp
13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client= environment:java.compiler=3D<NA>
13/08/22 13:44:21 INFO zo= okeeper.ZooKeeper: Client environment:os.name=3DLinux
13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:os.arch= =3Damd64
13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client envir= onment:os.version=3D2.6.32-279.el6.x86_64
13/08/22 13:44:21 INFO = zookeeper.ZooKeeper: Client environment:user.name=3Droot
13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:user.ho= me=3D/root
13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client env= ironment:user.dir=3D/
13/08/22 13:44:21 INFO zookeeper.ZooKeeper:= Initiating client connection, connectString=3Ddatlas-cloudera-m01:2181 ses= sionTimeout=3D600000 watcher=3Dorg.apache.hadoop.hive.ql.lockmgr.zookeeper.= ZooKeeperHiveLockManager$DummyWatcher@357c7988
13/08/22 13:44:21 DEBUG zookeeper.ClientCnxn: zookeeper.disableAutoWat= chReset is false
13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Ope= ning socket connection to server datlas-cloudera-m01/10.5.96.195:2181. Will not attempt to a= uthenticate using SASL (No se puede localizar una configuraci=F3n de inicio= de sesi=F3n)
13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Socket connection establi= shed to datlas-cloudera-m01/10.5.96.195:2181, initiating session
13/08/22 13:44:21= DEBUG zookeeper.ClientCnxn: Session establishment request sent on datlas-c= loudera-m01/10.5.96.1= 95:2181
13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Unable to read additional= data from server sessionid 0x0, likely server has closed socket, closing s= ocket connection and attempting reconnect
Interrupting... Be pati= ent, this might take some time.
13/08/22 13:44:21 INFO CliDriver: Interrupting... Be patient, this mig= ht take some time.
13/08/22 13:44:21 INFO ql.Driver: <PERFLOG = method=3DacquireReadWriteLocks>
13/08/22 13:44:22 INFO zookeep= er.ClientCnxn: Opening socket connection to server datlas-cloudera-m01/10.5.96.195:2181. Wil= l not attempt to authenticate using SASL (No se puede localizar una configu= raci=F3n de inicio de sesi=F3n)
13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Socket connection establi= shed to datlas-cloudera-m01/10.5.96.195:2181, initiating session
13/08/22 13:44:22= DEBUG zookeeper.ClientCnxn: Session establishment request sent on datlas-c= loudera-m01/10.5.96.1= 95:2181
13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Unable to read additional= data from server sessionid 0x0, likely server has closed socket, closing s= ocket connection and attempting reconnect

=3D=3D=3D=3D=3D=3D

Also, when I see the status of = the services with the cloudera manager UI I see a Bad Health in Zookeper an= d HBase. I restarted a lot of times Zookeper but it is in the same status.<= /div>

Why I can perform queries with Beeswax UI and not with Hive = console? And how can I solve this problem?

BTW, if= I type SHOW TABLES, I get the result, but a SELECT does not work


I will apreciate very much your help,
Thanks in advance.




--
= Nitin Pawar
--047d7b621fb2023c2c04e4dc6fd6--