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

column of BIGINT is not treat as dimensions for chart

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Web
    • Labels:
      None

      Description

      My query has appid,date, model, userNum, but the appid、date is not treat as dimension but metrics

        Activity

        Hide
        bob123 luguosheng added a comment -

        In query api response body, you can find a key named columnType. if it's value equals 91 or 92 or 93, it is a date type column; and -1, 1, 12 is a string type column,and -7, -6, -5, 3, 4, 5, 6, 7, 8 is a number type column.
        so we will set date or string type columns as dimension columns , and number type columns as measures.
        pls check the columnType in your response.

        Show
        bob123 luguosheng added a comment - In query api response body, you can find a key named columnType. if it's value equals 91 or 92 or 93, it is a date type column; and -1, 1, 12 is a string type column,and -7, -6, -5, 3, 4, 5, 6, 7, 8 is a number type column. so we will set date or string type columns as dimension columns , and number type columns as measures. pls check the columnType in your response.
        Hide
        yanghaogn Yang Hao added a comment - Reporter

        Thanks for you explation. If we have dimension which is number type, like appId, then it's treat as measure, and it's not so friendly. I think a friendly way is to divide it by dimension type and measure type

        Show
        yanghaogn Yang Hao added a comment - Reporter Thanks for you explation. If we have dimension which is number type, like appId, then it's treat as measure, and it's not so friendly. I think a friendly way is to divide it by dimension type and measure type

          People

          • Assignee:
            zhongjian Zhong,Jason
            Reporter:
            yanghaogn Yang Hao
            Request participants:
            None
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: