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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v2.1.0
• Fix Version/s: v2.4.1, v2.5.0
• Component/s: Driver - ODBC
• Environment: Windows 10;kylin v2.2.0;tableau desktop 10.4;kylin odbc v2.1.0
• Assignee: Chao Long
• Reporter: Hokyung Song
• Created: 10/Nov/17 04:45
• Updated: 09/Sep/18 05:53
• Resolved: 02/Jul/18 06:03

Description

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:

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"

---

environment

---

• kylin server : v2.2.0
• kylin odbc (for windows client) : v2.1.0
• tableau desktop : 10.4
• client os : windows 10 (64bit)

Issue Links

• is duplicated by: KYLIN-3413 ODBC error for bigint type in Tableau 10.4
• is duplicated by: KYLIN-3460 {fn CURRENT_DATE()} parse error
• links to: GitHub Pull Request #158