Hive JDBC Connection String
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.
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.