liyang created KYLIN-2456:
-----------------------------
Summary: select * query with join returning 0 rows
Key: KYLIN-2456
URL: https://issues.apache.org/jira/browse/KYLIN-2456
Project: Kylin
Issue Type: Bug
Reporter: liyang
Assignee: liyang
The root cause is similar to KYLIN-2367.
The query:
select * from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
inner JOIN test_category_groupings
ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND
test_kylin_fact.lstg_site_id = test_category_groupings.site_id
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
The plan:
OLAPToEnumerableConverter
OLAPJoinRel(condition=[=($4, $30)], joinType=[left])
OLAPJoinRel(condition=[AND(=($3, $21), =($4, $22))], joinType=[left])
OLAPJoinRel(condition=[=($1, $19)], joinType=[left])
OLAPTableScan(table=[[DEFAULT, TEST_KYLIN_FACT]], fields=[[0, 1, 2, 3, 4, 5, 6,
7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18]])
OLAPTableScan(table=[[EDW, TEST_CAL_DT]], fields=[[0, 1]])
OLAPTableScan(table=[[DEFAULT, TEST_CATEGORY_GROUPINGS]], fields=[[0, 1, 2, 3,
4, 5, 6, 7, 8]])
OLAPTableScan(table=[[EDW, TEST_SITES]], fields=[[0, 1, 2]])
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
