jdbc:hive2://hadoopnn1.estpak.ee:10000/;principal=hive/_h...@testhadoop.com;auth=kerberos;kerberosAuthType=fromSubject.
- this works. Added dot at the end of the string.
Margus (margusja) Roo
http://margus.roo.ee
skype: margusja
+372 51 48 780
On 16/09/16 14:38, Margus Roo wrote:
Hive version 1.2.1.2.3
Margus (margusja) Roo
http://margus.roo.ee
skype: margusja
+372 51 48 780
On 16/09/16 14:31, Margus Roo wrote:
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
