[
https://issues.apache.org/jira/browse/KYLIN-1313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15253297#comment-15253297
]
hongbin ma commented on KYLIN-1313:
-----------------------------------
reply from Richard:
Hello,
Cannot reply directly into the Jira ticket - dont know why. Anyway ...
I am okay with the warning for now but yes - warning is typically ignored ...
also the text of the warning is little confusing to me. Would be beneficial to
have the Host/Extended column names in the warning and also the value which
causes the non-unique mapping.
Also if you can provide toggle to make it error instead of warning (warning
could be the default behavior) then I would see this good idea for people who
want to detect an ETL errors this way ... I think if you define derived
dimension from fact table and non-uniqueness is detected many people may want
to stop load of the data and check what is wrong in the ETL. So toggle in Cube
Descriptor would be good idea ... I think.
Best regards, Richard.
> 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
> Fix For: v1.5.2
>
>
> 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)
