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

Posted to issues@kylin.apache.org by "nichunen (Jira)" <ji...@apache.org> on 2019/12/24 08:45:00 UTC

[jira] [Updated] (KYLIN-4120) Failed to query "select * from {lookup}" if a lookup table joined in two different models

     [ https://issues.apache.org/jira/browse/KYLIN-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

nichunen updated KYLIN-4120:
----------------------------
    Fix Version/s:     (was: v3.0.0-beta)
                   v3.1.0

> Failed to query "select * from {lookup}" if a lookup table joined in two different models
> -----------------------------------------------------------------------------------------
>
>                 Key: KYLIN-4120
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4120
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v3.0.0-alpha2
>            Reporter: nichunen
>            Assignee: Xiaoxiang Yu
>            Priority: Major
>             Fix For: v3.1.0
>
>
> Steps to reproduce:
> 1. Create two models with same lookup table (create snapshot)
> 2. Define different columns as dimensions in the two models
>     (Etc: in model ma, with column lookup.c1, lookup.c2; in model mb, with column lookup.c2, lookup.c3)
> 3. Create two cubes with the two models, and build the 2 cubes
> 4. Run query with "select * from {lookup}" with the 2 cubes in ready status, it should be failed with exception message like 
> "
> No model found for OLAPContext, CUBE_NOT_CONTAIN_ALL_COLUMN[1_39bd1072:SSB.DATES.D_DAYNUMINWEEK, 1_39bd1072:SSB.DATES.D_DAYOFWEEK, 1_39bd1072:SSB.DATES.D_DATE, 1_39bd1072:SSB.DATES.D_DAYNUMINMONTH, 1_39bd1072:SSB.DATES.D_DAYNUMINYEAR, 1_39bd1072:SSB.DATES.D_MONTH, 1_39bd1072:SSB.DATES.D_MONTHNUMINYEAR], CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_CONTAIN_ALL_COLUMN[1_39bd1072:SSB.DATES.D_YEARMONTHNUM, 1_39bd1072:SSB.DATES.D_YEAR], rel#218:OLAPTableScan.OLAP.[](table=[SSB, DATES],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]) while executing SQL: "select * from DATES LIMIT 50000"
> "



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