Support Questions
Find answers, ask questions, and share your expertise

setup Hive ODBC connection from MAC OS 10.12.3

setup Hive ODBC connection from MAC OS 10.12.3

i've configured the datasource connection but still i'm not able to connect to the hive databases.

IODBC version -- IODBC-SDK-3.52.12-MacOSX

Hive ODBC version -- 2.1.5.1006

Followed below link for setting up

https://hortonworks.com/wp-content/uploads/2016/08/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf --> page 32 and for kerberos enabled system

below are my configs.

Description = Hive Teast

HOST = test1234.abc-xyz.com

PORT = 10010 -> its correct port

HiveServerType = 2

AuthMech = 1

Schema = test

KrbRealm = hive/test1234.abc-xyz.com@HADOOP_TECH.ABC-XYZ.COM

KrbHostFQDN = test1234.abc-xyz.com

KrbServiceName = hive

ThriftTransport = SASL

DelegateKrbCreds = 1

Driver = /opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib