java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http: Invalid status 72

Apache's JIRA Issue Tracker | Hari Sankar Sivarama Subramaniyan | 2 years ago
  1. 0

    {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}

    Apache's JIRA Issue Tracker | 2 years ago | Hari Sankar Sivarama Subramaniyan
    java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http: Invalid status 72
  2. 0

    Beeline connection fails with: Peer indicated failure: Unsupported mechanism type PLAIN - Hortonworks

    hortonworks.com | 6 months ago
    java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://deala01876.corp:10000/default: Peer indicated failure: Unsupported mechanism type PLAIN
  3. 0

    GitHub comment 59#42850805

    GitHub | 3 years ago | prabhunkl
    java.lang.RuntimeException: java.sql.SQLException: Could not open connection to jdbc:hive2://168.69.200.211:10000/default: Peer indicated failure: Unsupported mechanism type PLAIN
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 59#42912981

    GitHub | 3 years ago | prabhunkl
    java.lang.RuntimeException: java.sql.SQLException: Could not open connection to jdbc:hive2://168.69.200.211:10000/default: Peer indicated failure: Unsupported mechanism type PLAIN
  6. 0

    GitHub comment 59#42915695

    GitHub | 3 years ago | ssshow16
    java.lang.RuntimeException: java.sql.SQLException: Could not open connection to jdbc:hive2://168.69.200.211:10000/default: Peer indicated failure: Unsupported mechanism type PLAIN

    4 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.thrift.transport.TTransportException

      Invalid status 72

      at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage()
    2. Apache Thrift
      TSaslClientTransport.open
      1. org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)
      2. org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:184)
      3. org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:307)
      4. org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)
      4 frames
    3. org.apache.hive
      HiveDriver.connect
      1. org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:203)
      2. org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:175)
      3. org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
      3 frames
    4. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:571)
      2. java.sql.DriverManager.getConnection(DriverManager.java:187)
      2 frames
    5. org.apache.hive
      Commands.connect
      1. org.apache.hive.beeline.DatabaseConnection.connect(DatabaseConnection.java:142)
      2. org.apache.hive.beeline.DatabaseConnection.getConnection(DatabaseConnection.java:207)
      3. org.apache.hive.beeline.Commands.connect(Commands.java:1139)
      4. org.apache.hive.beeline.Commands.connect(Commands.java:1060)
      4 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    7. org.apache.hive
      BeeLine.main
      1. org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:52)
      2. org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:976)
      3. org.apache.hive.beeline.BeeLine.execute(BeeLine.java:815)
      4. org.apache.hive.beeline.BeeLine.begin(BeeLine.java:772)
      5. org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:485)
      6. org.apache.hive.beeline.BeeLine.main(BeeLine.java:468)
      6 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    9. Hadoop
      RunJar.main
      1. org.apache.hadoop.util.RunJar.run(RunJar.java:221)
      2. org.apache.hadoop.util.RunJar.main(RunJar.java:136)
      2 frames