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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: v3.0.0-alpha2
• Fix Version/s: v3.1.0
• Component/s: Query Engine
• Assignee: Xiaoxiang Yu
• Reporter: nichunen
• Created: 31/Jul/19 12:08
• Updated: 02/Jun/20 02:30
• Resolved: 02/Jun/20 02:30

Description

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"
"