The driver version is 1.02.01.1001
I¹ve followed the instructions in the links you included to set up the
drill connection and made sure the TDC file is installed. I currently have
the MapRDrillODBC.tdc file in ~/My Documents/My Tableau
Repository/Datasources directory on windows. Here are the customizations
in the file, just in case I¹m not running the right version of it:
<customization name="CAP_CREATE_TEMP_TABLES" value="no"/>
<customization name="CAP_ODBC_BIND_FORCE_DATETIME_AS_CHAR"
value="no"/>
<customization name="CAP_ODBC_BIND_FORCE_DATE_AS_CHAR" value="no"/>
<customization name="CAP_ODBC_BIND_FORCE_SMALL_STRING_BUFFERS"
value="no"/>
<customization name="CAP_ODBC_BIND_SUPPRESS_INT64" value="no"/>
<customization name="CAP_ODBC_BIND_SUPPRESS_PREFERRED_TYPES"
value="no"/>
<customization name="CAP_ODBC_BIND_SUPPRESS_WIDE_CHAR" value="no"/>
<customization name="CAP_ODBC_CURSOR_DYNAMIC" value="no"/>
<customization name="CAP_ODBC_CURSOR_FORWARD_ONLY" value="yes"/>
<customization name="CAP_ODBC_CURSOR_KEYSET_DRIVEN" value="no"/>
<customization name="CAP_ODBC_CURSOR_STATIC" value="no"/>
<customization name="CAP_ODBC_ERROR_IGNORE_FALSE_ALARM"
value="no"/>
<customization name="CAP_ODBC_FETCH_CONTINUE_ON_ERROR" value="no"/>
<customization name="CAP_ODBC_FETCH_MASSIVE_BUFFERS" value="no"/>
<customization name="CAP_ODBC_FETCH_RESIZE_BUFFERS" value="no"/>
<customization name="CAP_ODBC_METADATA_STRING_LENGTH_UNKNOWN"
value="no"/>
<customization name="CAP_ODBC_METADATA_SUPPRESS_EXECUTED_QUERY"
value="yes"/>
<customization name="CAP_ODBC_METADATA_SUPPRESS_PREPARED_QUERY"
value="no"/>
<customization name="CAP_ODBC_METADATA_SUPPRESS_SQLCOLUMNS_API"
value="no"/>
<customization name="CAP_ODBC_REBIND_SKIP_UNBIND" value="no"/>
<customization name="CAP_ODBC_TRIM_VARCHAR_PADDING" value="no"/>
<customization name="CAP_ODBC_UNBIND_AUTO" value="no"/>
<customization name="CAP_ODBC_UNBIND_BATCH" value="no"/>
<customization name="CAP_ODBC_UNBIND_EACH" value="no"/>
<customization name="CAP_ODBC_USE_NATIVE_PROTOCOL" value="yes"/>
<customization name="CAP_QUERY_BOOLEXPR_TO_INTEXPR" value="no"/>
<customization name="CAP_QUERY_FROM_REQUIRES_ALIAS" value="no"/>
<customization name="CAP_QUERY_GROUP_ALLOW_DUPLICATES"
value="yes"/>
<customization name="CAP_QUERY_GROUP_BY_ALIAS" value="no"/>
<customization name="CAP_QUERY_GROUP_BY_DEGREE" value="no"/>
<customization name="CAP_QUERY_HAVING_REQUIRES_GROUP_BY"
value="no"/>
<customization name="CAP_QUERY_HAVING_UNSUPPORTED" value="no"/>
<customization name="CAP_QUERY_JOIN_ACROSS_SCHEMAS" value="yes"/>
<customization name="CAP_QUERY_JOIN_REQUIRES_SCOPE" value="no"/>
<customization name="CAP_QUERY_NULL_REQUIRES_CAST" value="no"/>
<customization name="CAP_QUERY_SELECT_ALIASES_SORTED" value="no"/>
<customization name="CAP_QUERY_SORT_BY_DEGREE" value="no"/>
<customization name="CAP_QUERY_SUBQUERIES" value="yes"/>
<customization name="CAP_QUERY_SUBQUERIES_WITH_TOP" value="no"/>
<customization name="CAP_QUERY_SUBQUERY_QUERY_CONTEXT"
value="yes"/>
<customization name="CAP_QUERY_TOP_N" value="no"/>
<customization name="CAP_QUERY_TOPSTYLE_LIMIT" value="yes"/>
<customization name="CAP_QUERY_TOPSTYLE_ROWNUM" value="no"/>
<customization name="CAP_QUERY_TOPSTYLE_TOP" value="no"/>
<customization name="CAP_QUERY_TOP_0_METADATA" value="no"/>
<customization name="CAP_QUERY_WHERE_FALSE_METADATA" value="yes"/>
<customization name="CAP_SELECT_INTO" value="no"/>
<customization name="CAP_SELECT_TOP_INTO" value="no"/>
<customization name="CAP_SUPPRESS_CONNECTION_POOLING" value="no"/>
<customization name="CAP_SUPPRESS_DISCOVERY_QUERIES" value="yes"/>
<customization name="CAP_SUPPRESS_DISPLAY_LIMITATIONS"
value="yes"/>
<customization name="SQL_TIMEDATE_ADD_INTERVALS" value="no"/>
<customization name="SQL_TIMEDATE_DIFF_INTERVALS" value="no"/>
Regards,
Ali Kashmar
EMC| Open Innovation Lab
O: 613.321.1334 | M: 613.219.9361
On 2016-03-08, 10:59 AM, "Andries Engelbrecht" <[email protected]>
wrote:
>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
>
