Return-Path: 
 <user-return-21138-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
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 B43F1186A9
	for <apmail-hive-user-archive@www.apache.org>;
 Mon, 19 Oct 2015 19:38:12 +0000 (UTC)
Received: (qmail 75564 invoked by uid 500); 19 Oct 2015 19:37:49 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 75500 invoked by uid 500); 19 Oct 2015 19:37:49 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 75489 invoked by uid 99); 19 Oct 2015 19:37:49 -0000
Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Oct 2015 19:37:49 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org)
 with ESMTP id D5512180DCD
	for <user@hive.apache.org>; Mon, 19 Oct 2015 19:37:48 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 2.879
X-Spam-Level: **
X-Spam-Status: No, score=2.879 tagged_above=-999 required=6.31
	tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1,
	HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01,
	SPF_PASS=-0.001] autolearn=disabled
Authentication-Results: spamd3-us-west.apache.org (amavisd-new);
	dkim=pass (2048-bit key) header.d=gmail.com
Received: from mx1-us-west.apache.org ([10.40.0.8])
	by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new,
 port 10024)
	with ESMTP id qmWS_zBysYkN for <user@hive.apache.org>;
	Mon, 19 Oct 2015 19:37:36 +0000 (UTC)
Received: from mail-qk0-f174.google.com (mail-qk0-f174.google.com
 [209.85.220.174])
	by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with
 ESMTPS id 3314B2303D
	for <user@hive.apache.org>; Mon, 19 Oct 2015 19:37:36 +0000 (UTC)
Received: by qkbl190 with SMTP id l190so27908106qkb.2
        for <user@hive.apache.org>; Mon, 19 Oct 2015 12:37:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:from:date:message-id:subject:to:content-type;
        bh=hJigZyLBxSKfZLawFQgynEjZdxvoMKFOaNJ7Fcc6Mvg=;
        b=gxlqviIV3Gk0RRSLlNqnWATXRd7jfFbsqCH5jG+TPYWeG80XrYYas/5eDqqgi8TQGl
         sUJvjYHsp4Pyk29u06yaSUDDCLnu6jw6Dhi92IM3ofcgGHQrHFE+5OFlJc3iVl4wJbxc
         8RoxTm653W4K9M5HGIDVUoRXl9mLzH/JDfVWHqz4n3ifIb99fYZsRFkXpEqVRbFhkBjI
         i1WxpmABT2CJnmUj7mhN4BWp4F8PmOFX7gOLUJ54nPGQAHOgcXcNSBIxAQbNChkLrskQ
         fOghaCH4ugOU+JjIzLkhmJAOpdN5Cz5H/zig9cjur60wZYWF88n2rwOOfF+eXCU65ba7
         N46A==
X-Received: by 10.55.40.224 with SMTP id o93mr38352732qko.106.1445283449283;
 Mon, 19 Oct 2015 12:37:29 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.55.111.66 with HTTP; Mon, 19 Oct 2015 12:37:09 -0700 (PDT)
From: Jerrick Hoang <jerrickhoang@gmail.com>
Date: Mon, 19 Oct 2015 12:37:09 -0700
Message-ID: 
 <CALHs=edVDM1q4CeB9sb4yWA=EuQfdXOCjGwyUVQ+OJ_NYeM+7A@mail.gmail.com>
Subject: Beeline and hiveserver2
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=001a11405fb69833d405227a46e3

--001a11405fb69833d405227a46e3
Content-Type: text/plain; charset=UTF-8

Hi all,

I'm trying to connect o HiveServer2 by using beeline client,

When I do
`/usr/local/hive/bin/beeline -u jdbc:hive2://<hostA>:9890`, I got

`Error: Failed to open new session: java.lang.RuntimeException:
java.lang.RuntimeException:
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException):
User: product is not allowed to impersonate anonymous (state=,code=0)
Beeline version 2.0.0-SNAPSHOT by Apache Hive`

Also when I do,
`/usr/local/hive/bin/beeline -u jdbc:hive2://<hostA>:9890 -n product`,

I also got

`Error: Failed to open new session: java.lang.RuntimeException:
java.lang.RuntimeException:
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException):
User: product is not allowed to impersonate product (state=,code=0)
Beeline version 2.0.0-SNAPSHOT by Apache Hive`

But when I put all the necessary information in a hive-site.xml

    <property>
      <name>hive.server2.thrift.port</name>
      <value>9890</value>
    </property>
    <property>
      <name>hive.server2.thrift.bind.host</name>
      <value><hostA></value>
    </property>

And do export HIVE_CONF_DIR=<path to hive-site.xml>, then run

`/usr/local/hive/bin/beeline -u jdbc:hive2://`

Anyone knows what's going on?

It was able to connect to the correct hiveserver2 (I can run queries
against it). I don't have any authentication setup (as far as I know) on
the Hiveserver2 side. Besides I am able to connect to it just fine using
the hacky method described above. Although I would like to connect to it in
code (using a java jdbc client) so the hacky method won't work.



Thanks!
Jerrick

--001a11405fb69833d405227a46e3
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi all,<div><br></div><div>I&#39;m trying to connect o Hiv=
eServer2 by using beeline client,</div><div><br></div><div>When I do=C2=A0<=
/div><div>`/usr/local/hive/bin/beeline -u jdbc:hive2://&lt;hostA&gt;:9890`,=
 I got=C2=A0</div><div><br></div><div>`Error: Failed to open new session: j=
ava.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.ip=
c.RemoteException(org.apache.hadoop.security.authorize.AuthorizationExcepti=
on): User: product is not allowed to impersonate anonymous (state=3D,code=
=3D0)</div><div>Beeline version 2.0.0-SNAPSHOT by Apache Hive`</div><div><b=
r></div><div>Also when I do,</div><div>`/usr/local/hive/bin/beeline -u jdbc=
:hive2://&lt;hostA&gt;:9890 -n product`,<br></div><div><br></div><div>I als=
o got=C2=A0</div><div><br></div><div><div>`Error: Failed to open new sessio=
n: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoo=
p.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationExc=
eption): User: product is not allowed to impersonate product (state=3D,code=
=3D0)</div><div>Beeline version 2.0.0-SNAPSHOT by Apache Hive`</div></div><=
div><br></div><div>But when I put all the necessary information in a hive-s=
ite.xml=C2=A0</div><div><br></div><div><div>=C2=A0 =C2=A0 &lt;property&gt;<=
/div><div>=C2=A0 =C2=A0 =C2=A0 &lt;name&gt;hive.server2.thrift.port&lt;/nam=
e&gt;</div><div>=C2=A0 =C2=A0 =C2=A0 &lt;value&gt;9890&lt;/value&gt;</div><=
div>=C2=A0 =C2=A0 &lt;/property&gt;</div><div>=C2=A0 =C2=A0 &lt;property&gt=
;</div><div>=C2=A0 =C2=A0 =C2=A0 &lt;name&gt;hive.server2.thrift.bind.host&=
lt;/name&gt;</div><div>=C2=A0 =C2=A0 =C2=A0 &lt;value&gt;&lt;hostA&gt;&lt;/=
value&gt;</div><div>=C2=A0 =C2=A0 &lt;/property&gt;</div></div><div><br></d=
iv><div>And do export HIVE_CONF_DIR=3D&lt;path to hive-site.xml&gt;, then r=
un=C2=A0</div><div><br></div><div>`/usr/local/hive/bin/beeline -u jdbc:hive=
2://`</div><div><br></div><div>Anyone knows what&#39;s going on?<br></div><=
div><br></div><div>It was able to connect to the correct hiveserver2 (I can=
 run queries against it). I don&#39;t have any authentication setup (as far=
 as I know) on the Hiveserver2 side. Besides I am able to connect to it jus=
t fine using the hacky method described above. Although I would like to con=
nect to it in code (using a java jdbc client) so the hacky method won&#39;t=
 work.</div><div><br></div><div><br></div><div><br></div><div>Thanks!</div>=
<div>Jerrick</div></div>

--001a11405fb69833d405227a46e3--