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

["Hokyung Song (JIRA)" <ji...@apache.org>]

Hokyung Song created KYLIN-3025:
-----------------------------------

             Summary: 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


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
(v6.4.14#64029)