[jira] [Commented] (KYLIN-1313) Enable deriving dimensions on non PK/FK

["Yerui Sun (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15095906#comment-15095906 ] 

Yerui Sun commented on KYLIN-1313:
----------------------------------

That's really a useful feature for us, but seems required some complicated working on it.
[~mahongbin], may you share your schedule for this issue? If there's already clearly designing, maybe we could work together to speed it up.

> Enable deriving dimensions on non PK/FK
> ---------------------------------------
>
>                 Key: KYLIN-1313
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1313
>             Project: Kylin
>          Issue Type: Improvement
>            Reporter: hongbin ma
>            Assignee: hongbin ma
>
> currently derived column has to be columns on look table, and the derived host column has to be PK/FK(It's also a problem when the lookup table grows every large). Sometimes columns on the fact exhibit deriving relationship too. Here's an example fact table:
> (dt date, seller_id bigint, seller_name varchar(100) , item_id bigint, item_url varchar(1000), count decimal, price decimal)
> seller_name is uniquely determined by each seller id, and item_url is uniquely determined by each item_id. The users does not expect to do filtering on columns like seller name or item_url, they just want to retrieve it when they do grouping/filtering on other dimensions like selller id, item id or even other dimensions like dt.



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