java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • NPE in thrift Sasl server
    via Stack Overflow by Ashu Pachauri
    ,
  • GitHub comment 59#42850805
    via GitHub by prabhunkl
    ,
  • {noformat} beeline -u 'jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http' -n hdiuser scan complete in 15ms Connecting to jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http Java heap space Beeline version 0.14.0.2.2.4.1-1 by Apache Hive 0: jdbc:hive2://localhost:10001/default (closed)> ^C hdiuser@headnode0:~$ {noformat} But it works if I use the deprecated param - {noformat} hdiuser@headnode0:~$ beeline -u 'jdbc:hive2://localhost:10001/default?hive.server2.transport.mode=http;httpPath=/' -n hdiuser scan complete in 12ms Connecting to jdbc:hive2://localhost:10001/default?hive.server2.transport.mode=http;httpPath=/ 15/04/28 23:16:46 [main]: WARN jdbc.Utils: ***** JDBC param deprecation ***** 15/04/28 23:16:46 [main]: WARN jdbc.Utils: The use of hive.server2.transport.mode is deprecated. 15/04/28 23:16:46 [main]: WARN jdbc.Utils: Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value> Connected to: Apache Hive (version 0.14.0.2.2.4.1-1) Driver: Hive JDBC (version 0.14.0.2.2.4.1-1) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 0.14.0.2.2.4.1-1 by Apache Hive 0: jdbc:hive2://localhost:10001/default> show tables; +------------------+--+ | tab_name | +------------------+--+ | hivesampletable | +------------------+--+ 1 row selected (18.181 seconds) 0: jdbc:hive2://localhost:10001/default> ^C hdiuser@headnode0:~$ ^C {noformat} The reason for the above message is : The url is wrong. Correct one: {noformat} beeline -u 'jdbc:hive2://localhost:10001/default;httpPath=/;transportMode=http' -n hdiuser {noformat} Note the ";" instead of "?". The deprecation msg prints the format as well: {noformat} Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value> {noformat}
    via by Hari Sankar Sivarama Subramaniyan,
  • hive
    via by Unknown author,
  • GitHub comment 59#42912981
    via GitHub by prabhunkl
    ,
  • GitHub comment 59#42915695
    via GitHub by ssshow16
    ,
    • java.sql.SQLException: [Simba]ImpalaJDBCDriver Error initialized or created transport for authentication: null. at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createTransport(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:247) Caused by: com.cloudera.support.exceptions.GeneralException: [Simba]ImpalaJDBCDriver Error initialized or created transport for authentication: null. ... 8 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.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:178) at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:288) at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37) at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createTransport(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:247) at TestConnection.main(TestConnection.java:24)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    17 more bugmates