[teiid-issues] [JBoss JIRA] (TEIID-3073) Tableau Connection Issues

Tableau Connection Issues ------------------------- Key: TEIID-3073 URL: https://issues.jboss.org/browse/TEIID-3073 Project: Teiid Issue Type: Bug Components: ODBC, Server Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.10 Attachments: server.log, server.log, tablue-wireshark.pcapng It has been reported that using Tableu with Teiid ODBC port show the following errors. These need to be investigated and fixed {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 'streamyx_sales (streamyx_sales.streamyx_sales) (TMJDV)': 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: ASCII(string) with parameter types 'string' 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: CHAR(integer) with parameter types 'float' This function is unsupported: CHAR(integer) with parameter types 'integer' 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: SPACE with parameter types 'float' This function is unsupported: SPACE(number) with parameter types 'integer' 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]) This is unsupported: SELECT ... INTO This is unsupported: Temporary tables {code}