kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "liyang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-2456) select * query with join returning 0 rows
Date Tue, 21 Feb 2017 05:32:44 GMT
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)

Mime
View raw message