You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by sh...@apache.org on 2015/10/26 10:07:53 UTC
[07/45] 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/ab7a363f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/ab7a363f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/ab7a363f
Branch: refs/heads/master
Commit: ab7a363f28c681a24b68bf4a7a905dd39382dd6c
Parents: 038eb59
Author: Li, Yang <ya...@ebay.com>
Authored: Tue Sep 22 16:31:31 2015 +0800
Committer: Li, Yang <ya...@ebay.com>
Committed: Tue Sep 22 16:31:31 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/ab7a363f/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