You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Zhong Yanghong (JIRA)" <ji...@apache.org> on 2018/09/09 05:54:03 UTC

[jira] [Closed] (KYLIN-3025) kylin odbc error : {fn CONVERT} for bigint type in tableau 10.4

     [ https://issues.apache.org/jira/browse/KYLIN-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zhong Yanghong closed KYLIN-3025.
---------------------------------

Resolved in release 2.4.1 (2018-09-09)

> 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
>            Assignee: Chao Long
>            Priority: Major
>             Fix For: v2.4.1, v2.5.0
>
>
> 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)