Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

setup Hive ODBC connection from MAC OS 10.12.3

setup Hive ODBC connection from MAC OS 10.12.3

New Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here