I have installed Hive ODBC driver version 1.2 on my windows host machine. Hadoop version 1.0.3 resides on Linux server. My goal is to test connectivity using Hive odbc driver on windows to the hive server on linux. In my hive-site.xml I found hive port as 9083. Hive version on hadoop cluster is 0.9. It does not have hive
From my windows client machine when I try to connect to the Hive on linux server I get the following error
Failed to establish connection
SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: ETIMEDOUT.
TESTS COMPLETED WITH ERROR.
Here is the configuration I used in the ODBC driver
port : 9083
Hive Server Type: Hive Server 2
I have earlier tried to user Hive Server Type = Hive Server 1 but it did not work either.
Do we need to do any setup for ODBC on linux server before we install the ODBC driver on windows machine?
Please help me with this.