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.
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.
Can you post your full connection string (masking out sensitive info, of course)?
Asked: 2017-07-13 08:16:18 -0500
Seen: 2,288 times
Last updated: Sep 01 '17
What JDBC URL are you using?
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?
Does this answer help? https://ask.streamsets.com/question/7/how-do-you-configure-an-impala-jdbc-driver-for-data-collector/
I have tried using the string with the help of this link only...but no positive result.
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.