[
https://issues.apache.org/jira/browse/KYLIN-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
nichunen updated KYLIN-4120:
----------------------------
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"
"
was:
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"
"
> 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
> Priority: Major
> 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 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
(v7.6.14#76016)
