kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiaoyu Wang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-1122) Kylin support detail data query from fact table
Date Tue, 03 Nov 2015 10:38:28 GMT
Xiaoyu Wang created KYLIN-1122:
----------------------------------

             Summary: 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


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message