Hi Prasad, My default hive-site.xml has following, doesn’t that mean “sasl” is disabled ?
<property> <name>hive.metastore.sasl.enabled</name> <value>false</value> <description>If true, the metastore Thrift interface will be secured with SASL. Clients must authenticate with Kerberos.</description> </property> Also the normal Hive login gives following output for show tables hive> show tables; OK ex_address invites invites2 pokes temp_address Time taken: 0.517 seconds, Fetched: 5 row(s) hive> However the beeline (without “auth=noSasl”) gives a strange error output, with “auth=noSasl” it just hangs and the exits with an exception $ beeline Beeline version 0.13.1 by Apache Hive beeline> !connect jdbc:hive2://finattr-comp-dev-01:10000/default "" "" org.apache.hive.jdbc.HiveDriver Connecting to jdbc:hive2://finattr-comp-dev-01:10000/default Connected to: Apache Hive (version 0.13.1) Driver: Hive JDBC (version 0.13.1) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://finattr-comp-dev-01:10000/def> 0: jdbc:hive2://finattr-comp-dev-01:10000/def> show tables; Error: For input string: "5000L" (state=,code=0) 0: jdbc:hive2://finattr-comp-dev-01:10000/def> Thanks - Atul From: Prasad Mujumdar [mailto:pras...@cloudera.com] Sent: Tuesday, December 02, 2014 10:21 AM To: user@hive.apache.org Subject: Re: JDBC/beeline client hangs with HiverServer2 (0.13.1) By default the sasl auth is enabled, you don't need to set 'auth=noSasl' unless you configured non-sasl auth. What errors did you see in the server log initially when noSasl option was not passed ? thanks Prasad On Tue, Dec 2, 2014 at 10:08 AM, Atul Paldhikar (apaldhik) <apald...@cisco.com<mailto:apald...@cisco.com>> wrote: Trying again, any pointers is really appreciated ! Thanks - Atul From: Atul Paldhikar (apaldhik) Sent: Monday, December 01, 2014 1:50 PM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: JDBC/beeline client hangs with HiverServer2 (0.13.1) Hi, I am trying to connect to Hive via JDBC client (Java code) but the connection hands forever. The same issue with beeline client also. I did google around and add “auth=noSasl” to my JDBC URL but still no luck. HiveServer2 startup : nohup hive --service hiveserver2 Beeline client : beeline>!connect jdbc:hive2://finattr-comp-dev-01:10000/default;auth=noSasl "" "" org.apache.hive.jdbc.HiveDriver Connecting to jdbc:hive2://finattr-comp-dev-01:10000/default;auth=noSasl 14/12/01 13:47:35 ERROR jdbc.HiveConnection: Error opening session 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:156) at org.apache.hive.service.cli.thrift.TCLIService$Client.OpenSession(TCLIService.java:143) at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:415) at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:193) at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:187) Thanks - Atul
