minor, test query of group by pushdown
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/520b05f7 Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/520b05f7 Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/520b05f7 Branch: refs/heads/master Commit: 520b05f744b13ad4cbd37372ae70272099ea48a1 Parents: 8d0b504 Author: Yang Li <liy...@apache.org> Authored: Sat Dec 3 12:33:14 2016 +0800 Committer: Li Yang <liy...@apache.org> Committed: Thu Dec 15 18:57:36 2016 +0800 ---------------------------------------------------------------------- .../src/test/resources/query/sql_subquery/query02.sql | 11 +++-------- 1 file changed, 3 insertions(+), 8 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/520b05f7/kylin-it/src/test/resources/query/sql_subquery/query02.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query02.sql b/kylin-it/src/test/resources/query/sql_subquery/query02.sql index 3ecfb1b..81b4887 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query02.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query02.sql @@ -18,19 +18,14 @@ SELECT week_beg_dt - ,sum(price) as sum_price + ,sum(price) FROM ( select test_cal_dt.week_beg_dt ,test_kylin_fact.price 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 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 + inner join edw.test_cal_dt as test_cal_dt + on test_kylin_fact.cal_dt = test_cal_dt.cal_dt ) t group by week_beg_dt -order by week_beg_dt \ No newline at end of file
