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.

Connecting ODBC to Spark Thrift Server

Highlighted

Connecting ODBC to Spark Thrift Server

New Contributor

Hi

 

I'm having problems connecting the Cloudera ODBC connector for Hive to the Spark Thrift Server.

I'm getting:

 

[S1000][unixODBC][Cloudera][Hardy] (81) Attempting to connect to an incorrect server type: . Please check your configuration.

 

These are the entries from my odbc.ini file:

[ClouderaHiveDSN64]
Description=Cloudera ODBC Driver for Apache Hive
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
HOST=[redacted]
PORT=10003 (running on a custom port)
Schema=default
HiveServerType=2
AuthMech=2
ThriftTransport=1

I've tried various combinations of AuthMech and ThrifTransport without success. The spark documentation,
here, says that the HiveServerType is 2.

Connecting via the JDBC connector works fine.

 

Environment:

  • Centos 7
  • Spark Thirft Server 1.6.2
  • unixODBC 2.3.1
  • ClouderaHiveODBC 2.5.20.1006-1

 

Can anyone help?

 

Thanks
Peter

2 REPLIES 2

Re: Connecting ODBC to Spark Thrift Server

Expert Contributor

Hi Peter,

 

Cloudera currently doesn't ship the Thrift server within Spark.  We recommend either connecting to HiveServer2 or Impala.

 

Thanks,

Jason Hubbard

Highlighted

Re: Connecting ODBC to Spark Thrift Server

New Contributor

Thanks for the reply Jason.

 

I'm trying to connect to the standard open source Apache distribution of Spark Thrift Server. Does the Cloudera connector support this?

 

Thanks

Peter

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