You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Xiaoyu Wang (JIRA)" <ji...@apache.org> on 2015/11/03 11:41:27 UTC
[jira] [Updated] (KYLIN-1122) Kylin support detail data query from
fact table
[ https://issues.apache.org/jira/browse/KYLIN-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiaoyu Wang updated KYLIN-1122:
-------------------------------
Attachment: 0002-KYLIN-1122-Kylin-support-detail-data-query-from-fact.patch
Here is the patch.
> 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
> Attachments: 0002-KYLIN-1122-Kylin-support-detail-data-query-from-fact.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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)