[KYLIN-3413] ODBC error for bigint type in Tableau 10.4

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Driver - ODBC
• Assignee: Unassigned
• Reporter: Le Anh Vu
• Created: 18/Jun/18 01:22
• Updated: 25/Jun/18 03:46
• Resolved: 25/Jun/18 03:46

Description

The issue is mentioned here.

https://issues.apache.org/jira/browse/KYLIN-3025

When I use Tableau 9.3 and 10.5, I have no problem connecting Kylin ODBC to Tableau. But in Tableau 10.4, I get error: No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc [expression=SUM, parameter=CAST($7):BIGINT, returnType=null]], 

When I check the query log, I found the difference in the SQL statement as follows:

Tableau 10.4: SUM({fn CONVERT(1, SQL_BIGINT)}) AS "sum_Number_of_Records_ok"
Tableau 10.5: SUM(1) AS "sum_Number_of_Records_ok"

I think it is a Tableau's problem, but can we update ODBC driver to fix this issue?

Issue Links

• duplicates: KYLIN-3025 kylin odbc error : {fn CONVERT} for bigint type in tableau 10.4