Hi
I am trying configure Toad for Hadoop SQL part. Kerberos in enabled in
my cluster.
I can see that Toad generates JDBC string ending with ...;
auth=kerberos;kerberosAuthType=fromSubject
When I testing this string in my beeline:
[margroo@hadoopnn1 ~]$ klist
Ticket cache: FILE:/tmp/krb5cc_1414255929
Default principal: marg...@realm.com
Valid starting Expires Service principal
09/16/2016 14:25:45 09/17/2016 00:25:45 krbtgt/realm....@realm.com
renew until 09/23/2016 14:25:39
I am getting error:
javax.security.sasl.SaslException: GSS initiate failed [Caused by
GSSException: No valid credentials provided (Mechanism level: Failed to
find any Kerberos tgt)]
When removing last part then it works:
0: jdbc:hive2://hadoopnn1.example.com:10000/ (closed)> !connect
jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com
Connecting to
jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com
Enter username for
jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com:
Enter password for
jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com:
Connected to: Apache Hive (version 1.2.1.2.3.4.0-3485)
Driver: Hive JDBC (version 1.2.1.2.3.4.0-3485)
Transaction isolation: TRANSACTION_REPEATABLE_READ
1: jdbc:hive2://hadoopnn1.example.com:10000/>
The problem is that Toad for Hadoop forcing ...
auth=kerberos;kerberosAuthType=fromSubject
--
Margus (margusja) Roo
http://margus.roo.ee
skype: margusja
+372 51 48 780