You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by ni...@apache.org on 2019/06/26 11:27:24 UTC
[kylin] 02/02: KYLIN-4041 minor,fix it
This is an automated email from the ASF dual-hosted git repository.
nic pushed a commit to branch 2.6.x
in repository https://gitbox.apache.org/repos/asf/kylin.git
commit 15f4339cfa3feccba76cde54d567fcb2d4c30039
Author: Yifei.Wu <va...@gmail.com>
AuthorDate: Tue Jun 25 18:44:51 2019 +0800
KYLIN-4041 minor,fix it
---
.../test/resources/query/sql_verifyContent/query02.sql | 17 ++++++++---------
.../query/sql_verifyContent/query02.sql.expected.xml | 2 +-
2 files changed, 9 insertions(+), 10 deletions(-)
diff --git a/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql b/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql
index df7a202..51920d0 100644
--- a/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql
+++ b/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql
@@ -19,16 +19,15 @@
-- This is a sample case
-select
- concat(meta_categ_name, CAST(null as VARCHAR)) as c1,
-
+select (
+ case when concat(meta_categ_name, cast(null as varchar)) is null then 'TRUE' else 'FALSE' end ) as C1
from test_kylin_fact
- left JOIN edw.test_cal_dt as test_cal_dt
- ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
- left JOIN 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
- left JOIN edw.test_sites as test_sites
- ON test_kylin_fact.lstg_site_id = test_sites.site_id
+ left join edw.test_cal_dt as test_cal_dt
+ on test_kylin_fact.cal_dt = test_cal_dt.cal_dt
+ left join 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
+ left join edw.test_sites as test_sites
+ on test_kylin_fact.lstg_site_id = test_sites.site_id
where meta_categ_name = 'Computers'
group by meta_categ_name
diff --git a/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql.expected.xml b/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql.expected.xml
index 580c0ee..acb2a97 100644
--- a/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql.expected.xml
+++ b/kylin-it/src/test/resources/query/sql_verifyContent/query02.sql.expected.xml
@@ -1,4 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
<dataset>
- <expect/>
+ <expect C1="TRUE "/>
</dataset>
\ No newline at end of file