[ https://issues.apache.org/jira/browse/KYLIN-2456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI updated KYLIN-2456: -------------------------------- Fix Version/s: v2.0.0 Component/s: Query Engine > select * query with join returning 0 rows > ----------------------------------------- > > Key: KYLIN-2456 > URL: https://issues.apache.org/jira/browse/KYLIN-2456 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Reporter: liyang > Assignee: liyang > Fix For: v2.0.0 > > > 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.4.14#64029)