1

I have challenge in setting up ODBC connectivity with Hive DB having Kerberos authentication.

Any sample using ODBC driver connection string/ODBC DSN dialog would be greatly helpful

M. Dudala
  • 11
  • 2
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Mar 02 '22 at 12:55

1 Answers1

0

See detail setting in pictures with text description for Data Source Name (DSN) in ODBC (with setting of Kerberos and SSL).:

  1. DNS source HiveTest HiveTest
  • I created Data Source Name: 'HiveTest'
  1. DSN, HiveTest detail setting HiveTest detail
  • Hive Server Type: Hive Server 2
  • Service Discovery Mode: No Service Discovery
  • Host name: bdp-head01-xxxx.prod (based on installation your solution)
  • Port: 10000 (as default for Hive)
  • Database: default (as default)
  • Authentication/Mechanism: Kerberos
  • Authentication/Realm: VN.HW.xxx.PROD (based on content in your keytab file)
  • Authentication/Host FQDN: _HOST (default accepted value)
  • Authentication/Service Name: hive
  • Thrift transport: SASL
  1. DSN, HiveTest with SSL detail SSL for HiveTest
  • SSL/Enable SSL: True
  • SSL/Trusted Certificates: xxx.pem (path to your PEM file)
JIST
  • 1,139
  • 2
  • 8
  • 30
  • 1
    Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 16 '22 at 22:00