[
https://issues.apache.org/jira/browse/KYLIN-2456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shaofeng SHI closed KYLIN-2456.
-------------------------------
> 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)
