]
Steven Hawkins resolved TEIID-3073.
-----------------------------------
Assignee: Steven Hawkins (was: Ramesh Reddy)
Resolution: Done
Marking as resolved based upon the last comment. We'll need to retest with the
changes that we have and see if there are options for Tableau to use simple aliases and
grouping expressions. Otherwise if needed we can come back and implement those as well.
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: Steven Hawkins
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}