[ https://issues.apache.org/jira/browse/KYLIN-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Roger Shi updated KYLIN-2830: ----------------------------- Description: SQL like: {code:sql} select sum(TEST_A.PRICE) as ITEM_CNT FROM TEST_KYLIN_FACT as TEST_A join ( select * from TEST_KYLIN_FACT where CAL_DT < DATE '2012-06-01' union select * from TEST_KYLIN_FACT 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. was: 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. > Union two subquery under join make SQL return null values > --------------------------------------------------------- > > Key: KYLIN-2830 > URL: https://issues.apache.org/jira/browse/KYLIN-2830 > 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 TEST_KYLIN_FACT where CAL_DT < DATE '2012-06-01' > union > select * from TEST_KYLIN_FACT 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)