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/09/29 03:04:13 UTC
[22/27] incubator-kylin git commit: KYLIN-943 update test sql for topN
KYLIN-943 update test sql for topN
Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/5753d4c3
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/5753d4c3
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/5753d4c3
Branch: refs/heads/2.x-staging
Commit: 5753d4c3774f061f058b24e2e6df5323ddb59280
Parents: 1a89346
Author: shaofengshi <sh...@apache.org>
Authored: Wed Sep 23 14:01:18 2015 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Tue Sep 29 09:02:21 2015 +0800
----------------------------------------------------------------------
query/src/test/resources/query/sql/query82.sql | 7 ++-----
1 file changed, 2 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/5753d4c3/query/src/test/resources/query/sql/query82.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query82.sql b/query/src/test/resources/query/sql/query82.sql
index 82c64d6..0e542bc 100644
--- a/query/src/test/resources/query/sql/query82.sql
+++ b/query/src/test/resources/query/sql/query82.sql
@@ -16,9 +16,7 @@
-- limitations under the License.
--
-SELECT
- cal_dt, seller_id from (select
- test_kylin_fact.cal_dt, seller_id, sum(test_kylin_fact.price) as gmv
+select test_kylin_fact.cal_dt, seller_id
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
@@ -26,5 +24,4 @@ SELECT
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
group by
- test_kylin_fact.cal_dt, test_kylin_fact.seller_id order by gmv desc limit 100
- ) as abc
+ test_kylin_fact.cal_dt, test_kylin_fact.seller_id order by sum(test_kylin_fact.price) desc limit 100