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/21 04:16:14 UTC

[08/13] 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/75b5005a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/75b5005a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/75b5005a

Branch: refs/heads/KYLIN-943
Commit: 75b5005a16cb23b5bbbddd989b49cccd9943dfc8
Parents: 2730fb6
Author: shaofengshi <sh...@apache.org>
Authored: Fri Sep 18 16:07:27 2015 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Mon Sep 21 10:11:54 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/75b5005a/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/75b5005a/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/75b5005a/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/75b5005a/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