kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Le Anh Vu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-3025) kylin odbc error : {fn CONVERT} for bigint type in tableau 10.4
Date Thu, 14 Jun 2018 03:17:00 GMT

    [ 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)

Mime
View raw message