Toad World® Forums

Connecting to HIVE Using ODBC Connector


#1

I am trying to connect to Hive Using ODBC connector.

  1. I downloaded ODBC driver 2.5 from Cloudera website

  2. Fill in all the information

getting Error : [Cloudera][ThriftExtension] (2) Error occured during authentication.

I can connect to HIVE successfully using Web Link


#2

Did you use the Cloudera Impala connection type with the Cloudera Hive Driver? Try that instead of Generic ODBC


#3

Hi , I am using Cloudera ODBC drive. I don’t know where I am going wrong.

Cloudera_ODBC.jpeg


#4

Hi NiknilP,

What’s the cloudera package version you are connecting to ? the latest one 5.14?

Besides hive ODBC connection, can you try the native Hive connection in Toad Data Point ?


#5

Hi Vincent,

I am using Toad Data Point Version 3.6 , which I think does not support HIVE connection.

So the only option to connect I could think of is using ODBC.


#6

Try the Trial version.

https://www.quest.com/register/54955/