C# Hive DB Connection sample with ODBC Driver using Kerberos Authentication

198 Views Asked by At

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

1

There are 1 best solutions below

1
On

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)