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)
