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/7737aee5 Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/7737aee5 Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/7737aee5 Branch: refs/heads/2.1.x Commit: 7737aee51f5bdaf14302e037bb83f14159c06750 Parents: d045a3a Author: Hongbin Ma <mahong...@apache.org> Authored: Tue Aug 22 11:16:41 2017 +0800 Committer: Hongbin Ma <mahong...@apache.org> Committed: Tue Aug 22 11:17:16 2017 +0800 ---------------------------------------------------------------------- .../query/sql_computedcolumn/query04.sql | 28 +++++++++++++++++++- .../sql_computedcolumn/query04.sql.compare | 28 ++++++++++++++++++-- 2 files changed, 53 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/7737aee5/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql b/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql index 780de5d..75af19b 100644 --- a/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql +++ b/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql @@ -1 +1,27 @@ -select count(*) as a , sum (F.DEAL_AMOUNT) as b from test_kylin_fact f inner join test_account a on f.seller_id = a.account_id inner join test_country c on country = account_country group by F.SELLER_ID_AND_COUNTRY_NAME +select count(*) as a , sum (TEST_KYLIN_FACT.DEAL_AMOUNT) as b , TEST_KYLIN_FACT.SELLER_ID_AND_COUNTRY_NAME as c + + + + +FROM TEST_KYLIN_FACT as TEST_KYLIN_FACT +INNER JOIN TEST_ORDER as TEST_ORDER +ON TEST_KYLIN_FACT.ORDER_ID = TEST_ORDER.ORDER_ID +INNER JOIN TEST_ACCOUNT as BUYER_ACCOUNT +ON TEST_ORDER.BUYER_ID = BUYER_ACCOUNT.ACCOUNT_ID +INNER JOIN TEST_ACCOUNT as SELLER_ACCOUNT +ON TEST_KYLIN_FACT.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID +INNER JOIN TEST_CATEGORY_GROUPINGS as 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 TEST_COUNTRY as BUYER_COUNTRY +ON BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY +INNER JOIN TEST_COUNTRY as SELLER_COUNTRY +ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY + + +group by TEST_KYLIN_FACT.SELLER_ID_AND_COUNTRY_NAME + + order by b + + + + http://git-wip-us.apache.org/repos/asf/kylin/blob/7737aee5/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql.compare ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql.compare b/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql.compare index 5ee361d..66ffc07 100644 --- a/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql.compare +++ b/kylin-it/src/test/resources/query/sql_computedcolumn/query04.sql.compare @@ -1,2 +1,26 @@ -select count(*) as a, sum (F.PRICE * F.ITEM_COUNT) as b from test_kylin_fact f - inner join test_account a on f.seller_id = a.account_id inner join test_country c on country = account_country group by CONCAT(A.ACCOUNT_ID, C.NAME) +select count(*) as a, sum (TEST_KYLIN_FACT.PRICE * TEST_KYLIN_FACT.ITEM_COUNT) as b, CONCAT(SELLER_ACCOUNT.ACCOUNT_ID, SELLER_COUNTRY.NAME) as c + + + +FROM TEST_KYLIN_FACT as TEST_KYLIN_FACT +INNER JOIN TEST_ORDER as TEST_ORDER +ON TEST_KYLIN_FACT.ORDER_ID = TEST_ORDER.ORDER_ID +INNER JOIN TEST_ACCOUNT as BUYER_ACCOUNT +ON TEST_ORDER.BUYER_ID = BUYER_ACCOUNT.ACCOUNT_ID +INNER JOIN TEST_ACCOUNT as SELLER_ACCOUNT +ON TEST_KYLIN_FACT.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID +INNER JOIN TEST_CATEGORY_GROUPINGS as 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 TEST_COUNTRY as BUYER_COUNTRY +ON BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY +INNER JOIN TEST_COUNTRY as SELLER_COUNTRY +ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY + + + + + + + + group by CONCAT(SELLER_ACCOUNT.ACCOUNT_ID, SELLER_COUNTRY.NAME) + order by b
