Cloudera ODBC Driver for Hive is used for direct SQL and HiveQL access to Apache Hadoop / Hive distributions, enabling Business Intelligence (BI), analytics and reporting on Hadoop / Hive -based data. The driver efficiently transforms an application’s SQL query into the equivalent form in HiveQL. This topic explains how to install the Cloudera ODBC driver, which is a fully compliant ODBC driver that supports multiple Hadoop distributions. Installing the Cloudera ODBC driver The Campaign Hive integration supports two drivers: Cloudera ODBC driver or DataDirect driver for Apache Hive. Nov 27, 2012 Once you have the Cloudera Hive ODBC driver installed you do not have to configure anything on your client machine, simply launch Tableau and connect using the Tableau connection dialog for Cloudera Hadoop Hive. I'm trying to log into Hortonworks Hadoop Hive from Tableau Desktop and looks like i don't have the right drivers installed since the 'sign in' button is greyed out. I was trying to download the drivers for ODBC from hortonworks and it redirects to Cloudera.
I configured unixodbc to use the hive connector from cloudera in my Linux Mint machine,but I keep receiving the following error when trying to connect to hive (e.g. using isql -v hive)
I think I set the /etc/odbcinst.ini and the ~/.odbc.ini in the correct way:
and my ~/.odbc.ini file contains:
Can you help me find out what is causing the error?
It may be that the driver is not linked to libodbcinst.so.
You could try a
or wherever libodbcinst.so is on your machine.
Nick GorhamNick Gorham
Are you sure that you ODBCInstLib is set properly?
I was hitting the same issue with a Vertica driver and my libodbcinst.so.1 ended up needing an absolute path: /usr/lib/x86_64-linux-gnu/libodbcinst.so.1
I determined the path by running a Find for libodbcinst.so.
stereo_futurestereo_future
Not the answer you're looking for? Browse other questions tagged hadoopodbchiveclouderaunixodbc or ask your own question.