[
https://issues.apache.org/jira/browse/KYLIN-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16511941#comment-16511941
]
Le Anh Vu commented on KYLIN-3025:
----------------------------------
My setup is similar and I also have this issue. When I upgrade my Tableau to
10.5, the problem no longer exist. But I can't upgrade my Tableau Server from
10.4 to 10.5 so my published workbook can't be read.
The difference between tableau query in 10.4 and 10.5 is as follows:
10.4: SUM(\{fn CONVERT(1, SQL_BIGINT)}) AS "sum_Number_of_Records_ok"
10.5: SUM(1) AS "sum_Number_of_Records_ok"
Can someone look at this bug?
> kylin odbc error : {fn CONVERT} for bigint type in tableau 10.4
> ---------------------------------------------------------------
>
> Key: KYLIN-3025
> URL: https://issues.apache.org/jira/browse/KYLIN-3025
> Project: Kylin
> Issue Type: Bug
> Components: Driver - ODBC
> Affects Versions: v2.1.0
> Environment: Windows 10;kylin v2.2.0;tableau desktop 10.4;kylin odbc
> v2.1.0
> Reporter: Hokyung Song
> Priority: Major
>
> In Tableau Desktop version 9.3, also it works very well.
> but..when I use measure field (bigint type of data) in Tableau Desktop
> version 10.4, it occured query error. (decimal type field works well.)
> I guess.. "{fn CONVERT}" function couldn't parsed. please support tableau
> 10.4 :)
> Detailed query example from tableau:
> {code}
> SELECT "MOMENT"."P_DT" AS "P_DT",
> SUM({fn CONVERT("MOMENT"."ACTIONCOUNT", SQL_BIGINT)}) AS
> "sum_ACTIONCOUNT_ok"
> FROM "TEST"."MOMENT" "MOMENT"
> GROUP BY "MOMENT"."P_DT"
> {code}
> ----
> environment
> ----
> * kylin server : v2.2.0
> * kylin odbc (for windows client) : v2.1.0
> * tableau desktop : 10.4
> * client os : windows 10 (64bit)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
