[
https://issues.apache.org/jira/browse/KYLIN-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16641079#comment-16641079
]
ASF GitHub Bot commented on KYLIN-3594:
---------------------------------------
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:
us...@infra.apache.org
> Select with Catalog fails
> -------------------------
>
> Key: KYLIN-3594
> URL: https://issues.apache.org/jira/browse/KYLIN-3594
> Project: Kylin
> Issue Type: Bug
> Reporter: Hosur Narahari
> Assignee: XiaoXiang Yu
> Priority: Major
> Fix For: v2.6.0
>
>
> By using DatabaseMetaData if we get catalog using getCatalogs() method, it
> return value "defaultCatalog". It returns actual hive schema when we execute
> getSchemas().
> According to JDBC contract, catalog.schema.table should be valid from clause
> and many query layers use that. But kylin fails when we execute that query.
> I've tried to write sample code piece for that below.
>
> _DatabaseMetaData db = conn.getMetaData();_
> _ResultSet catalogSet = db.getCatalogs();_
> _String catalog = "";_
> _if(catalogSet.next()) {_
> _catalog = catalogSet.getString("TABLE_CAT");_
> _}_
> _ResultSet schemaSet = db.getSchemas();_
> _String schema = "";_
> _if(schemaSet.next()) {_
> _schema = schemaSet.getString("TABLE_SCHEM");_
> _}_
> _StringBuilder sb = new StringBuilder("SELECT * FROM ");_
> _if(!catalog.isEmpty()) {_
> _sb.append(catalog + ".");_
> _}_
> _if(!schema.isEmpty()) {_
> _sb.append(schema + ".");_
> _}_
> _sb.append("kylin_sales limit 10");_
> _String query = sb.toString();_
> _Statement stat = conn.createStatement();_
> _ResultSet rs = stat.executeQuery(query);_
> _while(rs.next()) {_
> _System.out.println(rs.getObject("trans_id"));_
> _}_
> In short, the above snippet is executing the query,
> _select * from defaultCatalog.DEFAULT.kylin_sales._
>
> Same thing happens even with different schemas if we have like,
> _select * from defaultCatalog.test.kylin_sales_ also fails.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
