Tableau can generate different SQL syntax for a given function, and that is controlled by the TDC file.
What version of the ODBC driver are you using? Also make sure the TDC file shipped with the ODBC driver is being used by Tableau. If you are unsure see the documentation. https://drill.apache.org/docs/using-apache-drill-with-tableau-9-desktop/ <https://drill.apache.org/docs/using-apache-drill-with-tableau-9-desktop/> https://drill.apache.org/docs/using-apache-drill-with-tableau-9-server/ <https://drill.apache.org/docs/using-apache-drill-with-tableau-9-server/> --Andries > On Mar 8, 2016, at 7:43 AM, Kashmar, Ali <[email protected]> wrote: > > Hello, > > I’m trying to visualize data in HDFS using Tableau via Drill. I managed to > set it up and everything looks good, except that I ran into the issue > described in https://issues.apache.org/jira/browse/DRILL-962. The sql > fragment in question is this and it’s generated by Tableau : > > WHERE ((`Custom_SQL_Query`.`End Time` >= (CAST(CURRENT_TIMESTAMP AS DATE) + > -6 * INTERVAL '1' DAY)) AND (`Custom_SQL_Query`.`End Time` < > (CAST(CURRENT_TIMESTAMP AS DATE) + 1 * INTERVAL '1' DAY))) > > Are there any workarounds for this? Or should I just avoid using Date filters > in my dashboards for now? > > Regards, > > Ali Kashmar > EMC| Open Innovation Lab > O: 613.321.1334 | M: 613.219.9361
