I am trying to connect to either the native Hortonworks Hadoop hive connector or the other databases (ODBC) connector in tableau to hive.
For the native connector i get the error:
Unable to connect to the ODBC data source. Check drivers and connection properties
[Hortonworks][hardy] (34) Error from server: SSL_connect certificate verify failed
For the ODBC driver connector, I am able to establish connection, access a schema and tables. However when I drag and drop fields to row or column shelves I get the error message below;
Bad connection: Tableau could not connect to the data source.
[Hortonworks][hardy] (35) Error from server:error code: "0" error message: 'ExecuteStatement finished with operations state: ERROR_STATE'.
I am using 2018.1.3 and I have installed and successfully configured the ODBC driver. The driver version I currently have available and I am using is 2.1.7. Is this a driver version issue or an issue with the configuration? I read about TDC files which help Tableau operate more efficiently when using Hadoop hive ODBC driver. I coped the lines contained in a TDC file and saved in my tableau data sources. That is pretty much what I did. Please HELP.