You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "XiaoXiang Yu (JIRA)" <ji...@apache.org> on 2019/06/29 04:29:00 UTC

[jira] [Commented] (KYLIN-3628) Query with lookup table always use latest snapshot

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

XiaoXiang Yu commented on KYLIN-3628:
-------------------------------------

Thank you for reporting, [~seva_ostapenko], you have provided a very detailed analysis. I will check that.

> Query with lookup table always use latest snapshot
> --------------------------------------------------
>
>                 Key: KYLIN-3628
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3628
>             Project: Kylin
>          Issue Type: Improvement
>            Reporter: Na Zhai
>            Assignee: Na Zhai
>            Priority: Major
>             Fix For: v2.6.0
>
>
> If user queries a lookup table, Kylin will randomly selects a Cube (which has the snapshot of this lookup table) to answer it. This causes uncertainty when there are multiple cubes (share the same lookup): some cubes are newly built, some not. If Kylin picks an old cube, the query result is old.
> To remove this uncertainty, for such queries, either always use latest snapshot, or use earlist snapshot. We believe the "latest" version is better.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)