You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2016/06/16 02:23:05 UTC
[jira] [Commented] (KYLIN-1789) Couldn't use View as Lookup when
join type is "inner"
[ https://issues.apache.org/jira/browse/KYLIN-1789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15332914#comment-15332914 ]
Shaofeng SHI commented on KYLIN-1789:
-------------------------------------
Kylin does have a speical optimization for "inner": if a dimension column is the FK on fact table, and the join type is "inner", it will defer the dictionary build to lookup table's PK; While when materializing the views, as that dimension appeared to be on fact table, the view is skipped for materializing.
possible solutions:
1) remove that optimization on "inner"
or 2) materializing all lookup views of the model (regradless column source and join types)
or 3) check whether a dimension column is FK, if yes check whether the join type is "inner"; if all true, materializing the view.
> Couldn't use View as Lookup when join type is "inner"
> -----------------------------------------------------
>
> Key: KYLIN-1789
> URL: https://issues.apache.org/jira/browse/KYLIN-1789
> Project: Kylin
> Issue Type: Bug
> Components: Job Engine
> Affects Versions: v1.5.2, v1.5.2.1
> Reporter: Shaofeng SHI
> Assignee: Shaofeng SHI
> Fix For: v1.5.3
>
>
> Reported by Bhanu Mohanty in user mailing list:
> I am using kylin-1.5.2.1
> Added hive view as a look up table
> Getting error at Build Dimension Dictionary
> DEFAULT.kylin_intermediate_DEFAULT_*
> If the join is "inner"
> It works when I changed the join to "left"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)