[jira] [Created] (DRILL-4340) Tableau complains about the ODBC driver capabilities

["Oscar Morante (JIRA)" <ji...@apache.org>]

Oscar Morante created DRILL-4340:
------------------------------------

             Summary: Tableau complains about the ODBC driver capabilities
                 Key: DRILL-4340
                 URL: https://issues.apache.org/jira/browse/DRILL-4340
             Project: Apache Drill
          Issue Type: Improvement
    Affects Versions: 1.5.0
            Reporter: Oscar Morante


I'm testing Drill with Tableau via ODBC and when it connects it complains about some missing features:

{code}
This ODBC driver does not support important capabilities used by Tableau.
This unsupported function is required for relative date filters: The date part named 'week' for the date function: DATETRUNC(date_part, date, [start_of_week])
-----
Tableau identified the following warnings for the ODBC data source named 'test (s3.views.test)':
This aggregation is unsupported: Attribute
This aggregation is unsupported: Std. Dev
This aggregation is unsupported: Std. Dev (Pop.)
This aggregation is unsupported: Trunc Week Number
This aggregation is unsupported: Variance
This aggregation is unsupported: Variance (Pop.)
This function is unsupported: % with parameter types 'integer, integer'
This function is unsupported: ABS(number) with parameter types 'float'
This function is unsupported: ABS(number) with parameter types 'integer'
This function is unsupported: ACOS(number) with parameter types 'float'
This function is unsupported: ASIN(number) with parameter types 'float'
This function is unsupported: ATAN(number) with parameter types 'float'
This function is unsupported: ATAN2(y number, x number) with parameter types 'float, float'
This function is unsupported: COS(angle) with parameter types 'float'
This function is unsupported: COT(angle) with parameter types 'float'
This function is unsupported: DATEPART_DAYOFWEEK_INTERNAL with parameter types 'date'
This function is unsupported: DATEPART_WEEK_INTERNAL with parameter types 'date'
This function is unsupported: DATETIME with parameter types 'integer'
This function is unsupported: DEGREES(number) with parameter types 'float'
This function is unsupported: EXP(number) with parameter types 'float'
This function is unsupported: LN with parameter types 'float'
This function is unsupported: LN(number) with parameter types 'float'
This function is unsupported: LOG with parameter types 'float'
This function is unsupported: LOG(number, [base]) with parameter types 'float'
This function is unsupported: PI()
This function is unsupported: POWER with parameter types 'float, integer'
This function is unsupported: POWER with parameter types 'integer, integer'
This function is unsupported: POWER(number,power) with parameter types 'float, integer'
This function is unsupported: POWER(number,power) with parameter types 'integer, integer'
This function is unsupported: RADIANS(number) with parameter types 'float'
This function is unsupported: ROUND(number, [decimals]) with parameter types 'float'
This function is unsupported: ROUND(number, [decimals]) with parameter types 'float, integer'
This function is unsupported: SIGN(number) with parameter types 'float'
This function is unsupported: SIN(angle) with parameter types 'float'
This function is unsupported: SQRT(number) with parameter types 'float'
This function is unsupported: SQUARE with parameter types 'float'
This function is unsupported: TAN(angle) with parameter types 'float'
This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)