Member since
05-18-2021
4
Posts
0
Kudos Received
0
Solutions
07-19-2021
06:36 AM
I can see you are in HDP but you are using Cloudera Driver(https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-4.html) The first thing you need to do is start using Hortonworks Driver if you are using Ambari, link to download and configure is present in https://www.cloudera.com/downloads/hdp.html How to configure it? Check out the below link https://docs.cloudera.com/HDPDocuments/other/connectors/hive-jdbc/2.6.7/Simba-Hive-JDBC-Install-and-Configuration-Guide.pdf The error which had been shared should not harm connecting to Hive. To figure out the exact reason for the ODBC failure you need to enable TRACE logs as below You can configure the log level following those ways: If the client uses an ODBC on MS Windows machines, set the Log level on the Driver to TRACE and try a connection attempt, gather the driver logs: ODBC Driver Configuration > DataSourceAdministrator> select the DSN> Configure > Logging Options > set LogLevel: TRACE ODBC Driver Configuration > DataSourceAdministrator> select the DSN> Configure > Logging Options > set Log Path: "C:/" OK > OK ODBC Driver Configuration > DataSourceAdministrator> select the DSN> Configure > Test...
... View more