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)
