minor, fix CI
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/af4b5a55 Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/af4b5a55 Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/af4b5a55 Branch: refs/heads/master Commit: af4b5a552fe540c0e77389a6c1ecaa23dabb5375 Parents: ea10b6c Author: Roger Shi <rogershijich...@hotmail.com> Authored: Mon Sep 4 18:37:29 2017 +0800 Committer: Roger Shi <rogershijich...@gmail.com> Committed: Mon Sep 4 18:43:30 2017 +0800 ---------------------------------------------------------------------- kylin-it/src/test/resources/query/sql_union/query01.sql | 10 +++++----- kylin-it/src/test/resources/query/sql_union/query02.sql | 6 +++--- 2 files changed, 8 insertions(+), 8 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/af4b5a55/kylin-it/src/test/resources/query/sql_union/query01.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_union/query01.sql b/kylin-it/src/test/resources/query/sql_union/query01.sql index ec9a029..d5ff53f 100644 --- a/kylin-it/src/test/resources/query/sql_union/query01.sql +++ b/kylin-it/src/test/resources/query/sql_union/query01.sql @@ -1,13 +1,13 @@ -- union subquery under join -select sum(TEST_A.PRICE) as ITEM_CNT +select count(*) as cnt FROM TEST_KYLIN_FACT as TEST_A join ( - select sum(TEST_C.PRICE), TEST_C.TRANS_ID + select sum(TEST_C.PRICE), TEST_C.ORDER_ID from ( - select * from TEST_KYLIN_FACT where CAL_DT < DATE '2012-06-01' + select * from TEST_KYLIN_FACT where CAL_DT < DATE '2012-08-01' union select * from TEST_KYLIN_FACT where CAL_DT > DATE '2013-06-01' - ) TEST_C group by TRANS_ID + ) TEST_C group by ORDER_ID ) TEST_B -on TEST_A.TRANS_ID = TEST_B.TRANS_ID +on TEST_A.ORDER_ID = TEST_B.ORDER_ID group by TEST_A.SELLER_ID http://git-wip-us.apache.org/repos/asf/kylin/blob/af4b5a55/kylin-it/src/test/resources/query/sql_union/query02.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_union/query02.sql b/kylin-it/src/test/resources/query/sql_union/query02.sql index 7ba023f..db7e29a 100644 --- a/kylin-it/src/test/resources/query/sql_union/query02.sql +++ b/kylin-it/src/test/resources/query/sql_union/query02.sql @@ -1,10 +1,10 @@ -- union subquery under join -select sum(TEST_A.PRICE) as ITEM_CNT +select count(*) as cnt FROM TEST_KYLIN_FACT as TEST_A join ( - select * from TEST_KYLIN_FACT where CAL_DT < DATE '2012-06-01' + select * from TEST_KYLIN_FACT where CAL_DT < DATE '2012-08-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 +on TEST_A.ORDER_ID = TEST_B.ORDER_ID group by TEST_A.SELLER_ID
