question Re: Herberized HDP 2.4 - not able to connect using Beeline in Support Questions

Herberized HDP 2.4 - not able to connect using Beeline

karan_alang1 — Wed, 07 Dec 2016 09:58:01 GMT

Hi - i've a kerberized HDP 2.4 cluster, and i'm trying to access Hive using Beeline.

Command used ->

!connect jdbc:hive2://sandbox.hortonworks.com:10001/default;principal=hive/sandbox.hortonworks.com@EXAMPLE.COM;hive.server2.transport.mode=binary;hive.server2.thrift.http.path=cliservice;auth=kerberos;hive.server2.thrift.sasl.qop=auth-int

Error :

Error: Could not open client transport with JDBC Uri: jdbc:hive2://sandbox.hortonworks.com:10001/default;principal=hive/sandbox.hortonworks.com@EXAMPLE.COM;hive.server2.transport.mode=binary;hive.server2.thrift.http.path=cliservice: java.net.ConnectException: Connection refused (state=08S01,code=0)

reference ->

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_dataintegration/content/beeline-vs-hive-cli.html

Pls let me know what needs to be done ?

Also, what is the username/password to be put in, on firing the command above ?

I tried leaving it blank, and also the Unix hive username/passwd, but the error is the same.

Re: Herberized HDP 2.4 - not able to connect using Beeline

knarayanan — Wed, 07 Dec 2016 11:39:48 GMT

try that !connect jdbc:hive2://sandbox.hortonworks.com:10001/default;principal=hive/sandbox.hortonworks.com@EXAMPLE.COM

are you sure that is the correct principal? When you use kerberos, you are using a key to provide credentials. You do not need username and password

Re: Herberized HDP 2.4 - not able to connect using Beeline

karan_alang1 — Wed, 07 Dec 2016 15:04:55 GMT

@Karthik Narayanan,

- yes, the principal is correct for user - hive & I was able to use this command to connect to hive using beeline using the command you provided.. thanks for that.

command -> !connect jdbc:hive2://sandbox.hortonworks.com:10000/default;principal=hive/sandbox.hortonworks.com@EXAMPLE.COM