The MapR ODBC driver ships with a customization file for Tableau. Make sure that Tableau is using the TDC file (works with either server or desktop). http://drill.apache.org/docs/using-apache-drill-with-tableau-9-desktop/ <http://drill.apache.org/docs/using-apache-drill-with-tableau-9-desktop/>
Specifically these 2 lines should resolve the issue <customization name='SQL_TIMEDATE_ADD_INTERVALS' value='no' /> <customization name='SQL_TIMEDATE_DIFF_INTERVALS' value='no' /> This will change the SQL syntax to use EXTRACT, that is working since Drill 1.2 or 1.4 and later. --Andries > On Aug 16, 2016, at 8:25 AM, scott <[email protected]> wrote: > > Hello, > I ran across an error when using Tableau to access Drill. It seems that > when you try to convert some date attributes in Tableau, it tries to run an > SQL query that includes a function called TIMESTAMPADD which has a > parameter of SQL_TSI_HOUR. The result is an error that says SQL_TSI_HOUR > not found in any table. > I found that a Jira ticket is already open to add this function into Drill, > DRILL-3610, but there isn't a release date for it yet. > I'm wondering if anyone has run across this before, and might have a > workaround to share? > > Thanks, > Scott
