I'm having problems connecting the Cloudera ODBC connector for Hive to the Spark Thrift Server.
[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.
Can anyone help?
Cloudera currently doesn't ship the Thrift server within Spark. We recommend either connecting to HiveServer2 or Impala.
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?