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:44:27 UTC
[jira] [Comment Edited] (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:comment-tabpanel&focusedCommentId=14987051#comment-14987051 ]
Xiaoyu Wang edited comment on KYLIN-1122 at 11/3/15 10:43 AM:
--------------------------------------------------------------
Here is the patch for 1.x-staging
was (Author: wangxiaoyu):
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)
Re: [jira] [Comment Edited] (KYLIN-1122) Kylin support detail data
query from fact table
Posted by Luke Han <lu...@gmail.com>.
Hi Xiaoyu,
This is really really fantastic contribution!
@all, please help to try and test with your case and data, and give
more feedback to Xiaoyu.
Can't wait to try it...would love to include this as key feature in
v1.2 release!
Thanks.
Luke
Best Regards!
---------------------
Luke Han
On Tue, Nov 3, 2015 at 6:44 PM, Xiaoyu Wang (JIRA) <ji...@apache.org> wrote:
>
> [
> https://issues.apache.org/jira/browse/KYLIN-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14987051#comment-14987051
> ]
>
> Xiaoyu Wang edited comment on KYLIN-1122 at 11/3/15 10:43 AM:
> --------------------------------------------------------------
>
> Here is the patch for 1.x-staging
>
>
> was (Author: wangxiaoyu):
> 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)
>