Cloudera Community
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Jagbir
user rank
New Contributor

Re: Problem in getting impala connection using JDB...

by New Contributor in Support Questions
‎03-21-2017 07:14 AM
‎03-21-2017 07:14 AM
I am able to connect finally.    I had to authenticate using kerberos so initially I was authenticating like this :   Sample () { Configuration conf = new Configuration(); conf.set("hadoop.security.authentication", "Kerberos"); UserGroupInformation.setConfiguration(conf); UserGroupInformation.loginUserFromKeytab(user, keytabPath); ugi = UserGroupInformation.getLoginUser(); } after this URL of this type :  jdbc:impala://myhost.example.com:21050/;principal=impala/myhost.example.com@H2.EXAMPLE.COM;SSL=1;sslTrustStore=trustStorePath;trsutStorePassword=xyz; Creating datasource and get connection. This did not work and was giving above mentioned exception.   Later Modification : Using AuthMech = 1 in URL and setting KrbHostFQDN,  KrbServiceName,  KrbAuthType in URL.   Not executing Sample() after this and just setting these properties :    java.security.krb5.conf = Your krb5.conf path java.security.auth.login.config = login.ini where login.ini is like this    Client { com.sun.security.auth.module.Krb5LoginModule required useKeyTab=true keyTab="PathToTheKeyTab" principal="cloudera@CLOUDERA" doNotPrompt=true; };   Hopefully this may help to debug other guys struggling like me 🙂   ... View more

Problem in getting impala connection using JDBC

by New Contributor in Support Questions
‎03-20-2017 05:22 PM
‎03-20-2017 05:22 PM
I am trying to connect to imapala using jdbc and I am getting the following exception     java.sql.SQLException: [Simba][ImpalaJDBCDriver](500151) Error setting/closing session: {0}. at com.cloudera.hivecommon.api.HS2Client.openSession(Unknown Source) at com.cloudera.hivecommon.api.HS2Client.<init>(Unknown Source) at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createClient(Unknown Source) at com.cloudera.hivecommon.core.HiveJDBCCommonConnection.connect(Unknown Source) at com.cloudera.impala.core.ImpalaJDBCConnection.connect(Unknown Source) at com.cloudera.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source) at com.cloudera.jdbc.common.AbstractDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500151) Error setting/closing session: {0}. ... 9 more Caused by: org.apache.thrift.transport.TTransportException at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84) at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378) at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297) at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69) at org.apache.hive.service.cli.thrift.TCLIService$Client.recv_OpenSession(TCLIService.java:159) at com.cloudera.hivecommon.api.HS2ClientWrapper.recv_OpenSession(Unknown Source) at org.apache.hive.service.cli.thrift.TCLIService$Client.OpenSession(TCLIService.java:146) at com.cloudera.hivecommon.api.HS2ClientWrapper.OpenSession(Unknown Source) at com.cloudera.hivecommon.api.HS2Client.openSession(Unknown Source) at com.cloudera.hivecommon.api.HS2Client.<init>(Unknown Source) at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createClient(Unknown Source) at com.cloudera.hivecommon.core.HiveJDBCCommonConnection.connect(Unknown Source) at com.cloudera.impala.core.ImpalaJDBCConnection.connect(Unknown Source) at com.cloudera.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source) at com.cloudera.jdbc.common.AbstractDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at com.priceline.cache22dataconsole.test.TestImpalaConnection.main(TestImpalaConnection.java:56)   Anyone has any Idea why I am getting this exception.This is the code example :  Authentication is successful. Class.forName("com.cloudera.impala.jdbc41.Driver"); connection = DriverManager.getConnection(CONNECTION_URL);   ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎04-03-2017 11:57 AM
Community Statistics
Member Since ‎03-13-2017 12:14 PM
Last Visited ‎04-03-2017 11:57 AM
Posts 2