[ https://issues.apache.org/jira/browse/KYLIN-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiaoxiang Yu closed KYLIN-4120. ------------------------------- Resolution: Cannot Reproduce > 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)