First check the driver version. If you look at the Tableau logs we will echo back the ODBC version level the driver reports. Search the logs for a statement like:
ODBCProtocol: driver ODBC version: 03.52. The number at the end indicates the ODBC version level. If it is less than 03.00, thn the driver needs to be upgraded.
If you get warnings when you connect about capabilities not supported, check with your database vendor to see if they have an updated driver that supports more capabilities. Not all drivers will work with Tableau.
If you are connecting to a database for which we have a named connection option, then use the named connection. The named choices are optimized for the particular database where Tableau has specific knowledge of the databases capabilities.
Let me know if this helped you or if your require more assistance
2 of 2 people found this helpful
Hi Charan Thota,
This seems to be related to this open ticket: [DRILL-1343] Drill should time out after short time if a storage plugin is unresponsive. - ASF JIRA
As a work around, I found that adding the following settings into the hbase configuration solves the hang issue.
After updating the storage config, make sure you restart all the drillbits.
If you are trying to access tables on hbase, make sure you have maprdb turn on as they will be listed there with the default settings.
And if you don't require hbase, turning it off and restart drillbits also resolved the issue for me, too.