From dev-return-14372-archive-asf-public=cust-asf.ponee.io@kylin.apache.org Sun Oct 7 16:36:37 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 2DDB9180677 for ; Sun, 7 Oct 2018 16:36:37 +0200 (CEST) Received: (qmail 63864 invoked by uid 500); 7 Oct 2018 14:36:36 -0000 Mailing-List: contact dev-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@kylin.apache.org Delivered-To: mailing list dev@kylin.apache.org Received: (qmail 63853 invoked by uid 99); 7 Oct 2018 14:36:36 -0000 Received: from ec2-52-202-80-70.compute-1.amazonaws.com (HELO gitbox.apache.org) (52.202.80.70) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 Oct 2018 14:36:36 +0000 From: GitBox To: dev@kylin.apache.org Subject: [GitHub] shaofengshi closed pull request #279: KYLIN-3594 remove unnecessary sql files in integration test Message-ID: <153892299557.19141.4435201179130624584.gitbox@gitbox.apache.org> Date: Sun, 07 Oct 2018 14:36:35 -0000 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit shaofengshi closed pull request #279: KYLIN-3594 remove unnecessary sql files in integration test URL: https://github.com/apache/kylin/pull/279 This is a PR merged from a forked repository. As GitHub hides the original diff on merge, it is displayed below for the sake of provenance: As this is a foreign pull request (from a fork), the diff is supplied below (as it won't show otherwise due to GitHub magic): 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 2705f783d7..0000000000 --- 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 454779c0af..0000000000 --- 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 ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: users@infra.apache.org With regards, Apache Git Services