question Re: How to access Hive in CLI using non Root users in HDP 2. 5 ?? in Archives of Support Questions (Read Only)

How to access Hive in CLI using non Root users in HDP 2. 5 ??

subash_sharma — Wed, 07 Dec 2016 17:53:56 GMT

Hi,

Can i login to hive using non root user through CLI and what are the different and easiest way to access hive. Please note that my environment is kerberized.

Thanks you,

Subash

Re: How to access Hive in CLI using non Root users in HDP 2. 5 ??

rajkumar_singh — Wed, 07 Dec 2016 18:13:17 GMT

@subash sharmayes you can access hive cli after getting the valid kerberos credential for non-root user, given that this user belongs to hdfs group.

Re: How to access Hive in CLI using non Root users in HDP 2. 5 ??

subash_sharma — Wed, 07 Dec 2016 18:16:37 GMT

@Rajkumar Singh

Hey Raj Thanks for the quick response. Can you please send me the syntax to list down users in HDFS as well as in Kerberos.

Re: How to access Hive in CLI using non Root users in HDP 2. 5 ??

rajkumar_singh — Wed, 07 Dec 2016 18:21:16 GMT

try with ambari-qa

klist -kt /etc/security/keytabs/smokeuser.headless.keytab

Keytab name: FILE:/etc/security/keytabs/smokeuser.headless.keytab

KVNO Timestamp Principal

---- ----------------- --------------------------------------------------------

1 11/22/16 11:24:27 ambari-qa-rks242secure@EXAMPLE.COM

then obtain ticket

kinit -kt /etc/security/keytabs/smokeuser.headless.keytab ambari-qa-rks242secure@EXAMPLE.COM

Re: How to access Hive in CLI using non Root users in HDP 2. 5 ??

subash_sharma — Wed, 07 Dec 2016 18:28:17 GMT

Hey @Rajkumar can you please send me the syntax to login to hive cli for normal non root users and kerberos primcipals

Re: How to access Hive in CLI using non Root users in HDP 2. 5 ??

rajkumar_singh — Wed, 07 Dec 2016 18:31:01 GMT

after getting these credential using above command just do execute hive

Re: How to access Hive in CLI using non Root users in HDP 2. 5 ??

vperiasamy — Wed, 07 Dec 2016 23:43:57 GMT

please note Hive CLI is not supported by Ranger.

Re: How to access Hive in CLI using non Root users in HDP 2. 5 ??

slachterman — Thu, 08 Dec 2016 04:17:48 GMT

Please use beeline as it is the CLI for HiveServer2, the hive CLI (and HiveServer1) is deprecated. Syntax to connect to kerberized Hive is

beeline -u jdbc:hive2://<HIVE_HOST_FQDN>:10000;principal=hive/<hive_host_fqdn>@YOUR.REALM

You must kinit first. You will authenticate to HiveServer2 using the credentials associated with the Kerberos principal that you use to request a TGT from your KDC.

Users that can authenticate to HS2 don't need to be part of the hdfs group. They need to be present as Kerberos principals in the KDC for the realm which you used to kerberize the cluster, or within some other realm that is trusted by the former.