Roger Shi created KYLIN-2829: -------------------------------- Summary: Union two subquery under join make SQL return null values Key: KYLIN-2829 URL: https://issues.apache.org/jira/browse/KYLIN-2829 Project: Kylin Issue Type: Bug Reporter: Roger Shi
SQL like: {code:sql} select sum(TEST_A.PRICE) as ITEM_CNT FROM TEST_KYLIN_FACT as TEST_A join ( select * from ITEM_CNT where CAL_DT < DATE '2012-06-01' union select * from ITEM_CNT where CAL_DT > DATE '2013-06-01' ) TEST_B on TEST_A.TRANS_ID = TEST_B.TRANS_ID group by TEST_A.SELLER_ID {code} returns null values. -- This message was sent by Atlassian JIRA (v6.4.14#64029)