Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-3025

kylin odbc error : {fn CONVERT} for bigint type in tableau 10.4

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: v2.1.0
    • Fix Version/s: v2.5.0
    • Component/s: Driver - ODBC
    • Labels:
      None
    • Environment:
      Windows 10;kylin v2.2.0;tableau desktop 10.4;kylin odbc v2.1.0

      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)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                hkssong Hokyung Song
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: