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 <yang...@ebay.com> Authored: Tue Sep 22 16:29:59 2015 +0800 Committer: Li, Yang <yang...@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