Installed Hive ODBC driver and a HDP DSN has been set up as below, when connecting to hiveserver via excel, always got error “SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: No more data to read.”
But I can successfully connect to hiverserver2 with user name and password. My question is how can I connect to old hiveserver? Checked the hiveserver services is running and port 9083 and 10000 are listening.
Hive Server Type: Hive Server 1
Authentication: No Authentication
Driver Version: V18.104.22.1685
Running connectivity tests…
Failed to establish connection
SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: No more data to read.
TESTS COMPLETED WITH ERROR.