[ https://issues.apache.org/jira/browse/KYLIN-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15204098#comment-15204098 ]
Xiaoyu Wang commented on KYLIN-1122: ------------------------------------ I merge the code into {{1.3.x}} and {{master}} branch. IT tests is passed at the two branches! For the 1.3.x branch. {{SQLDigest.isRawQuery}} is a little different with master branch:in 1.3.x branch,the {{metricColumns}} may be empty in some scenario like {noformat} SELECT sum(test_kylin_fact.price) as GMV , count(*) as TRANS_CNT FROM test_kylin_fact inner JOIN edw.test_cal_dt as test_cal_dt ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt inner JOIN test_category_groupings ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id inner JOIN edw.test_sites as test_sites ON test_kylin_fact.lstg_site_id = test_sites.site_id inner JOIN edw.test_seller_type_dim as test_seller_type_dim ON test_kylin_fact.slr_segment_cd = test_seller_type_dim.seller_type_cd {noformat} So I change to derive from both {{groupbyColumns}} and {{aggregations}}! > Kylin support detail data query from fact table > ----------------------------------------------- > > Key: KYLIN-1122 > URL: https://issues.apache.org/jira/browse/KYLIN-1122 > Project: Kylin > Issue Type: New Feature > Components: Query Engine > Affects Versions: v1.2 > Reporter: Xiaoyu Wang > Assignee: liyang > Fix For: Backlog > > Attachments: > 0001-KYLIN-1122-Kylin-support-detail-data-query-from-fact(2.x-staging).patch, > 0001-KYLIN-1122-Kylin-support-detail-data-query-from-fact(update-v2-1.x-staging).patch, > > 0001-KYLIN-1122-Kylin-support-detail-data-query-from-fact-new-impl-under-refactoring-2.x-staging.patch > > > 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!) -- This message was sent by Atlassian JIRA (v6.3.4#6332)