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

["nichunen (JIRA)" <ji...@apache.org>]

nichunen created KYLIN-4120:
-------------------------------

             Summary: 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: nichunen
             Fix For: v3.0.0-beta


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
"
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
(v7.6.14#76016)