You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by ma...@apache.org on 2015/09/22 12:46:52 UTC
[5/6] incubator-kylin git commit: KYLIN-1039 fix CI,
add all joins in query81.sql
KYLIN-1039 fix CI, add all joins in query81.sql
Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/cc15d63f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/cc15d63f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/cc15d63f
Branch: refs/heads/KYLIN-942-test
Commit: cc15d63f0d58ae8cd6c6de383d40123239225a74
Parents: 10febfa
Author: Li, Yang <ya...@ebay.com>
Authored: Tue Sep 22 16:29:59 2015 +0800
Committer: Li, Yang <ya...@ebay.com>
Committed: Tue Sep 22 16:29:59 2015 +0800
----------------------------------------------------------------------
query/src/test/resources/query/sql/query81.sql | 7 ++++++-
1 file changed, 6 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cc15d63f/query/src/test/resources/query/sql/query81.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query81.sql b/query/src/test/resources/query/sql/query81.sql
index 7302a7d..93868e7 100644
--- a/query/src/test/resources/query/sql/query81.sql
+++ b/query/src/test/resources/query/sql/query81.sql
@@ -18,6 +18,11 @@
select test_cal_dt.week_beg_dt, sum(price) as GMV
from test_kylin_fact
- inner JOIN edw.test_cal_dt as test_cal_dt ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
+inner JOIN edw.test_cal_dt as test_cal_dt
+ ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
+ inner 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
+ inner JOIN edw.test_sites as test_sites
+ ON test_kylin_fact.lstg_site_id = test_sites.site_id
where test_cal_dt.week_beg_dt between DATE '2013-09-01' and DATE '2013-10-01' and (lstg_format_name='FP-GTC' or 'a' = 'b')
group by test_cal_dt.week_beg_dt
\ No newline at end of file