[jira] [Created] (KYLIN-4428) Left join result is empty

["Zhong Yanghong (Jira)" <ji...@apache.org>]

Zhong Yanghong created KYLIN-4428:
-------------------------------------

             Summary: Left join result is empty
                 Key: KYLIN-4428
                 URL: https://issues.apache.org/jira/browse/KYLIN-4428
             Project: Kylin
          Issue Type: Improvement
          Components: Query Engine
            Reporter: Zhong Yanghong
            Assignee: Zhong Yanghong


The below sql 
{code}
select
    f.cal_dt
from test_kylin_fact f
where
    f.cal_dt not in (
        select cal_dt from EDW.TEST_CAL_DT where week_beg_dt = date'2012-01-01'
    )
{code}
should be equal to 
{code}
select f.cal_dt 
from test_kylin_fact f
left join (         select cal_dt from EDW.TEST_CAL_DT where week_beg_dt = date'2012-01-01'     ) s
on f.cal_dt = s.cal_dt
where s.cal_dt IS NULL
{code}

However, when run the later sql with left join, it returns no results.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)