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 <tcots8888@gmail.com> 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
|