Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Hive2 JDBC connection with Kerberos

  1. #1
    Join Date
    Nov 2010
    Posts
    16

    Default Hive2 JDBC connection with Kerberos

    Hi,

    Do we know if it's possible?

    I have a valid Kerbero tkt:

    Code:
    C:\Program Files\Java\jre6\bin>klist
    
    Credentials cache: C:\Users\user\krb5cc_user
    
    
    Default principal: user@xxx.xxxxxxxx.LAN, 1 entry found.
    
    
    [1]  Service Principal:  krbtgt/xxx.xxxxxxxx.LAN@xxx.xxxxxxxx.LAN
         Valid starting:  Oct 28, 2013 12:11
         Expires:         Oct 29, 2013 12:11

    I installed the latest big data plugin (could connect OK with the Hive2 driver before kerberos was installed)

    I specifed the principal as a parameter so that my connection string looks like:

    Code:
     jdbc:hive2://xxx.xx.x.xxx:10000/default;PRINCIPAL=user
    I'm getting this error message:

    Code:
    Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
    Could not establish connection to  jdbc:hive2://xxx.xx.x.xxx:10000/default;PRINCIPAL=user: Peer indicated failure: Unsupported mechanism type PLAIN
    Thanks in advance!!

  2. #2
    Join Date
    Nov 2010
    Posts
    16

    Default

    Update:

    After investigating a little more, I changed the connection string to:

    Code:
     jdbc:hive2://xxx.xx.x.xxx:10000/default;principal=hive/user@xxx.xxxxxxx.LAN
    The error I'm getting now is:

    Code:
    Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
    Could not establish connection to jdbc:hive2://xxx.xx.x.xxx:10000/default;principal=hive/user@xxx.xxxxxxx.LAN: GSS initiate failed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.