This is an automated email from the ASF dual-hosted git repository.
nic 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 55f7140 KYLIN-4041 minor,fix it
55f7140 is described below
commit 55f714007b21b8b7e197dd99d0f081b77fb4efce
Author: Yifei.Wu <vafuler...@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
