How to connect to Hive using Kerberos from QlikSense?

[#1]

I would like to connect to Hartonworks Hive table which uses Kerberos authentication from QlikSense. The default Apache Hive connector provided doesn't have option for Kerberos authentication.

Any help on this is welcome!

Thank you!

[#2]

@Krishna P

Please download this hortonworks version

Features

SQL Up Leveling/ Full ANSI SQL Support

SQL up-levelling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.

Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant

Support for Advanced Security Features

This Hive ODBC driver supports advanced security mechanisms including Kerberos, Sentry and Ranger for authentication and authorization across all your distributions.

Performance Tuning

Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)

Cross-platform

Support Use one ODBC driver for all versions of SQL that works across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX

If this link provides the solution please accept the answer

HTH

[#3]

@Krishna P

Any updates

[#4]

Hi Geoffrey,

Stuck bit with the driver configuration. We are already using "Hartonworks Hive ODBC Driver" and compared to the set up information of that, in Progress Data Direct Connnect, configuration is bit varying and I didn't succeed yet connecting to Hive.

Specifically for example, we have Realm, FQDN like information in existing driver, where these information can't be given to "Progress Data Direct Connect" driver it seems.

Do you have any idea of this?

Thank you!

Krishna.