Hi Atul,
The setting you pasted is for the metastore's authentication (setting to
false means SASL is disabled there). The setting you want is:
hive.server2.authentication – Authentication mode, default NONE. Options
are NONE, NOSASL, KERBEROS, LDAP, PAM and CUSTOM.
See https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2
Andrew
On 12/2/14, 11:48 PM, Atul Paldhikar (apaldhik) wrote:
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