CODEWITHSUNDEEP
c#odbckerberoshivedb
M. Dudala
M. Dudala

Reputation: 11

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

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

Upvotes: 1

Views: 238

Answers (1)

JIST
JIST

Reputation: 1360

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)

Upvotes: 0

Related Questions