You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by sh...@apache.org on 2018/10/07 14:36:37 UTC
[kylin] branch master updated: KYLIN-3594 Remove unnecessary sql
files in integration test
This is an automated email from the ASF dual-hosted git repository.
shaofengshi pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/kylin.git
The following commit(s) were added to refs/heads/master by this push:
new 25f094b KYLIN-3594 Remove unnecessary sql files in integration test
25f094b is described below
commit 25f094b19cd73f435911d838243cc3e808f8ec01
Author: hit-lacus <hi...@126.com>
AuthorDate: Sun Oct 7 21:42:33 2018 +0800
KYLIN-3594 Remove unnecessary sql files in integration test
---
.../test/resources/query/sql_snowflake/query07.sql | 23 ----------------------
.../test/resources/query/sql_snowflake/query08.sql | 14 -------------
2 files changed, 37 deletions(-)
diff --git a/kylin-it/src/test/resources/query/sql_snowflake/query07.sql b/kylin-it/src/test/resources/query/sql_snowflake/query07.sql
deleted file mode 100644
index 2705f78..0000000
--- a/kylin-it/src/test/resources/query/sql_snowflake/query07.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-SELECT
-
-count(*) as cnt
-
-FROM defaultCatalog.TEST_KYLIN_FACT as TEST_KYLIN_FACT
-INNER JOIN defaultCatalog.TEST_ORDER as TEST_ORDER
-ON TEST_KYLIN_FACT.ORDER_ID = TEST_ORDER.ORDER_ID
-INNER JOIN defaultCatalog.TEST_ACCOUNT as BUYER_ACCOUNT
-ON TEST_ORDER.BUYER_ID = BUYER_ACCOUNT.ACCOUNT_ID
-INNER JOIN defaultCatalog.TEST_ACCOUNT as SELLER_ACCOUNT
-ON TEST_KYLIN_FACT.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID
-INNER JOIN defaultCatalog.EDW.TEST_CAL_DT as TEST_CAL_DT
-ON TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.CAL_DT
-INNER JOIN defaultCatalog.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 defaultCatalog.EDW.TEST_SITES as TEST_SITES
-ON TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_SITES.SITE_ID
-INNER JOIN defaultCatalog.EDW.TEST_SELLER_TYPE_DIM as TEST_SELLER_TYPE_DIM
-ON TEST_KYLIN_FACT.SLR_SEGMENT_CD = TEST_SELLER_TYPE_DIM.SELLER_TYPE_CD
-INNER JOIN defaultCatalog.TEST_COUNTRY as BUYER_COUNTRY
-ON BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY
-INNER JOIN defaultCatalog.TEST_COUNTRY as SELLER_COUNTRY
-ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY
diff --git a/kylin-it/src/test/resources/query/sql_snowflake/query08.sql b/kylin-it/src/test/resources/query/sql_snowflake/query08.sql
deleted file mode 100644
index 454779c..0000000
--- a/kylin-it/src/test/resources/query/sql_snowflake/query08.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT
-
-count(*) as cnt, sum(price) as sum_price, SELLER_COUNTRY.NAME
-
-FROM TEST_KYLIN_FACT as TEST_KYLIN_FACT
-INNER JOIN defaultCatalog.TEST_ACCOUNT as SELLER_ACCOUNT
-ON TEST_KYLIN_FACT.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID
-INNER JOIN defaultCatalog.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 defaultCatalog.TEST_COUNTRY as SELLER_COUNTRY
-ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY
-
-where SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL=1
-group by SELLER_COUNTRY.NAME
\ No newline at end of file