Ask Your Question

Hive JDBC Connection String

asked 2017-07-13 08:16:18 -0600

anonymous user


Hi Team, i am unable to connect to hive by jdbc connection string while using jdbc lookup. I am getting error like JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl=

can anyone pls help me in this.

edit retag flag offensive close merge delete


What JDBC URL are you using?

metadaddy gravatar imagemetadaddy ( 2017-07-13 23:21:18 -0600 )edit

jdbc:hive2://example:10000;AuthMech=3;SSL=1;SSLKeyStore=/opt/cloudera/security/pki/server.jks;SSLKeyStorePwd=****;UID=****;PWD=**** this is the jdbc url i am using.I have tried connecting with a user id & pwd.if i have to connet using kerberos authentication how the connection string will look like?

Varun gravatar imageVarun ( 2017-07-14 06:07:51 -0600 )edit

I have tried using the string with the help of this link only...but no positive result.

Varun gravatar imageVarun ( 2017-07-18 03:32:23 -0600 )edit

You talk about Kerberos auth, but the AuthMech=3 indicates LDAP authentication. Can you clarify which you are trying to do? Also, please let us know exactly which Hive driver you are using.

jeff gravatar imagejeff ( 2017-07-19 15:32:40 -0600 )edit

2 Answers

Sort by ยป oldest newest most voted

answered 2017-09-01 01:19:32 -0600

Mufy gravatar image

Just wanted to add a quick note here from my recent experience while trying to setup Hive Drift following this.

At one point, I hit a similar message and I was using MySQL as Hive metastore back-end. I realized I'd missed to update the configuration in $SDC_CONF/sdc-security.policy as per this which I could see you mention having already gone over.

The other thing I'd to do to get out of the muddle was to upgrade my Connector-J version for MySQL to the latest.

My strong guess at this point is this has mostly got to do with the wrong driver getting caught in the middle.

edit flag offensive delete link more

answered 2017-07-21 11:34:58 -0600

Can you post your full connection string (masking out sensitive info, of course)?

edit flag offensive delete link more



Varun gravatar imageVarun ( 2017-07-24 07:21:53 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-13 08:16:18 -0600

Seen: 487 times

Last updated: Sep 01 '17