[jira] [Commented] (KYLIN-5106) Failed to build lookup table

["Yaqian Zhang (Jira)" <ji...@apache.org>]

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

Yaqian Zhang commented on KYLIN-5106:
-------------------------------------

Hi:

This error is due to duplicate key values in the columns in your lookup table that have a join relationship with the fact table. Kylin will check the duplicate keys when building the snapshot. If duplicate keys are detected, an error will be reported.

To avoid this problem, you need to fix the duplicate key values in the lookup table.

If a dimension table with duplicate key values does not actually need to create a table snapshot, you can view this issue: https://issues.apache.org/jira/browse/KYLIN-5067.

> Failed to build lookup table
> ----------------------------
>
>                 Key: KYLIN-5106
>                 URL: https://issues.apache.org/jira/browse/KYLIN-5106
>             Project: Kylin
>          Issue Type: Bug
>    Affects Versions: v4.0.0
>            Reporter: qingquanzhang
>            Priority: Major
>         Attachments: empTest_b532af1aabef4d0f8b29450744d499fc01 (1).log
>
>
> Detect Resource successed
> Build Cube with Spark failed



--
This message was sent by Atlassian Jira
(v8.3.4#803005)