kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "hongbin ma (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-1313) Enable deriving dimensions on non PK/FK
Date Wed, 13 Jan 2016 06:21:39 GMT
hongbin ma created KYLIN-1313:
---------------------------------

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

Mime
View raw message