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/18 10:08:01 UTC

incubator-kylin git commit: KYLIN-943 update test sql for topN

Repository: incubator-kylin
Updated Branches:
  refs/heads/KYLIN-943 fc17d9985 -> 300454d87


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/300454d8
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/300454d8
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/300454d8

Branch: refs/heads/KYLIN-943
Commit: 300454d8788ef4e9ce0bf72cd339abbf60f909e1
Parents: fc17d99
Author: shaofengshi <sh...@apache.org>
Authored: Fri Sep 18 16:07:27 2015 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Fri Sep 18 16:07:27 2015 +0800

----------------------------------------------------------------------
 .../test/java/org/apache/kylin/common/topn/TopNCounterTest.java   | 2 ++
 .../localmeta/cube_desc/test_kylin_cube_topn_desc.json            | 1 +
 query/src/test/resources/query/sql/query81.sql                    | 3 +--
 query/src/test/resources/query/sql/query82.sql                    | 3 +--
 4 files changed, 5 insertions(+), 4 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/300454d8/core-common/src/test/java/org/apache/kylin/common/topn/TopNCounterTest.java
----------------------------------------------------------------------
diff --git a/core-common/src/test/java/org/apache/kylin/common/topn/TopNCounterTest.java b/core-common/src/test/java/org/apache/kylin/common/topn/TopNCounterTest.java
index edc9ce2..dab45b1 100644
--- a/core-common/src/test/java/org/apache/kylin/common/topn/TopNCounterTest.java
+++ b/core-common/src/test/java/org/apache/kylin/common/topn/TopNCounterTest.java
@@ -22,6 +22,7 @@ import org.apache.commons.io.FileUtils;
 import org.apache.commons.lang.RandomStringUtils;
 import org.apache.commons.math3.distribution.ZipfDistribution;
 import org.apache.kylin.common.util.Pair;
+import org.junit.Ignore;
 import org.junit.Test;
 
 import java.io.*;
@@ -30,6 +31,7 @@ import java.util.Comparator;
 import java.util.List;
 import java.util.Map;
 
+@Ignore("For collecting accuracy statistics, not for functional test")
 public class TopNCounterTest {
 
     protected static int TOP_K;

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/300454d8/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_topn_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_topn_desc.json b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_topn_desc.json
index 96c3ace..7c2c6ff 100644
--- a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_topn_desc.json
+++ b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_topn_desc.json
@@ -2,6 +2,7 @@
   "uuid": "4334a905-1fc6-4f67-985c-38fa5aeafd92",
   "name": "test_kylin_cube_topn_desc",
   "description": null,
+  "engine_type": 2,
   "dimensions": [
     {
       "id": 0,

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/300454d8/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 e580281..39a14a5 100644
--- a/query/src/test/resources/query/sql/query81.sql
+++ b/query/src/test/resources/query/sql/query81.sql
@@ -18,9 +18,8 @@
 
 SELECT 
  seller_id 
- ,sum(test_kylin_fact.price) as GMV 
  FROM test_kylin_fact left join edw.test_cal_dt as test_cal_dt
  ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
  where test_kylin_fact.cal_dt < DATE '2013-02-01' 
  group by 
- test_kylin_fact.seller_id order by gmv desc limit 100
+ test_kylin_fact.seller_id order by sum(test_kylin_fact.price) desc limit 100

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/300454d8/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 6b62753..29d67b8 100644
--- a/query/src/test/resources/query/sql/query82.sql
+++ b/query/src/test/resources/query/sql/query82.sql
@@ -18,9 +18,8 @@
 
 SELECT 
  test_kylin_fact.cal_dt, seller_id 
- ,sum(test_kylin_fact.price) as GMV 
  FROM test_kylin_fact 
 left JOIN edw.test_cal_dt as test_cal_dt
  ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
  group by 
- test_kylin_fact.cal_dt, test_kylin_fact.seller_id order by gmv desc limit 100
+ test_kylin_fact.cal_dt, test_kylin_fact.seller_id order by sum(test_kylin_fact.price) desc limit 100