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/10/25 14:12:20 UTC
[7/7] incubator-kylin git commit: minor, fix CI failure for subquery
minor, fix CI failure for subquery
Signed-off-by: honma <ho...@ebay.com>
Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/c93d05c1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/c93d05c1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/c93d05c1
Branch: refs/heads/2.x-staging
Commit: c93d05c1386ff157540f928688518882af9eb754
Parents: e8ecdc6
Author: lidongsjtu <li...@126.com>
Authored: Fri Oct 23 18:43:56 2015 +0800
Committer: honma <ho...@ebay.com>
Committed: Sun Oct 25 21:15:21 2015 +0800
----------------------------------------------------------------------
.../test/resources/query/sql_subquery/query08.sql | 18 ++++++++++++++----
1 file changed, 14 insertions(+), 4 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/c93d05c1/query/src/test/resources/query/sql_subquery/query08.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql_subquery/query08.sql b/query/src/test/resources/query/sql_subquery/query08.sql
index e7fd6a7..48da204 100644
--- a/query/src/test/resources/query/sql_subquery/query08.sql
+++ b/query/src/test/resources/query/sql_subquery/query08.sql
@@ -18,15 +18,25 @@
SELECT t1.week_beg_dt, t1.sum_price, t2.cnt
FROM (
- select test_cal_dt.week_beg_dt, sum(test_kylin_fact.price) as sum_price
+ select test_cal_dt.week_beg_dt, sum(price) as sum_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 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
group by test_cal_dt.week_beg_dt
) t1
inner join (
select test_cal_dt.week_beg_dt, count(*) as cnt
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
group by test_cal_dt.week_beg_dt
) t2
-on t1.week_beg_dt=t2.week_beg_dt
+on t1.week_beg_dt=t2.week_beg_dt
\ No newline at end of file