search

amazon-archives / sql-jdbc

🔍 Open Distro for Elasticsearch JDBC Driver
Apache License 2.0
111 stars 49 forks source link

Tableau - SQL JDBC support #2

Closed CarlMeadows closed 3 years ago

CarlMeadows commented 5 years ago

Add support for Tableau to the SQL JDBC driver.

epical-mi commented 5 years ago

Just tested the JDBC driver against Tableau. During its connection testing process, Tableau seems to try to create a temporary table to test some SQL capabilities of the JDBC driver/DB and then drops the table. I can see these error messages from ES logs. As these features are not supported, the connection fails.

java.sql.SQLFeatureNotSupportedException: Unsupported query: CREATE LOCAL TEMPORARY TABLE XT____AB_________D__C_C______B___F_B_BC___1_Connect_CheckCreateTempTableCap (     COL INTEGER     ) ON COMMIT PRESERVE ROWS
java.sql.SQLFeatureNotSupportedException: Unsupported query: DROP TABLE XT____AB_________D__C_C______B___F_B_BC___1_Connect_CheckCreateTempTableCap
rupal-bq commented 4 years ago

You can add <customization name='CAP_CREATE_TEMP_TABLES' value='no'/> in .tdc file to avoid creating temporary tables. For more information check Connecting Tableau with Open Distro for Elasticsearch.