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

Kylin support detail data query from fact table

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • v1.2
    • v1.3.1, v1.5.1
    • Query Engine
    • None
    • Patch

    Description

      Now Kylin does not support query correct detail rows from fact table like:
      select column1,column2,column3 from fact_table
      The jira KYLIN-1075 add the "SUM" function on the measure column if defined.
      But only the column number type is support.

      I change some code to support this issue:
      Add a "VALUE" measure function : the same value and datatype in the input and output of this function.

      If you want to query detail data from fact table
      require:
      1.Configure the column which not dimensions to "VALUE" or "SUM" measure.(If not configure measure function in the column will get NULL value)
      2.The source table must has an unique value column and configure it as dimension.

      If you have the better solution please comment here.

      2016-03-21:
      The final solution:
      Add a "RAW" measure function which return the list of all the value by one key.
      If query detail data from fact table
      require:
      Configure the column to "RAW" measure.(If not configure measure function in the column and do the RAW query will get the incorrect value!)

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            liyang.gmt8@gmail.com liyang
            wangxiaoyu Xiaoyu Wang
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment