kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiaoyu Wang (JIRA)" <>
Subject [jira] [Commented] (KYLIN-1122) Kylin support detail data query from fact table
Date Wed, 13 Jan 2016 07:45:39 GMT


Xiaoyu Wang commented on KYLIN-1122:

for the "3)" adjustSqlDigest may be contain the parameter "cubeDesc"  will be better, In the
raw custom function scenario, will use all columns or dimensions.

> Kylin support detail data query from fact table
> -----------------------------------------------
>                 Key: KYLIN-1122
>                 URL:
>             Project: Kylin
>          Issue Type: New Feature
>          Components: Query Engine
>    Affects Versions: v1.2
>            Reporter: Xiaoyu Wang
>            Assignee: liyang
>             Fix For: v2.0, v1.3
>         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.

This message was sent by Atlassian JIRA

View raw message