Mailing-List: contact commits-help@kylin.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@kylin.incubator.apache.org
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: shaofengshi@apache.org
To: commits@kylin.incubator.apache.org
Date: Tue, 29 Sep 2015 01:04:03 -0000
Message-Id: <e3ca3fcdc7d8493996da0e9be8c45432@git.apache.org>
In-Reply-To: <02bc6849f3034b18ba5384077469e67d@git.apache.org>
References: <02bc6849f3034b18ba5384077469e67d@git.apache.org>
Subject: [12/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/a01c2132
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/a01c2132
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/a01c2132

Branch: refs/heads/2.x-staging
Commit: a01c2132c7cfec7346d0781dbe24168ff2821f71
Parents: 26f9412
Author: shaofengshi <shaofengshi@apache.org>
Authored: Fri Sep 18 16:07:27 2015 +0800
Committer: shaofengshi <shaofengshi@apache.org>
Committed: Tue Sep 29 09:01:23 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                    | 2 +-
 query/src/test/resources/query/sql/query82.sql                    | 3 +--
 4 files changed, 5 insertions(+), 3 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/a01c2132/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/a01c2132/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/a01c2132/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 93868e7..895718b 100644
--- a/query/src/test/resources/query/sql/query81.sql
+++ b/query/src/test/resources/query/sql/query81.sql
@@ -25,4 +25,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
  inner JOIN edw.test_sites as test_sites
  ON test_kylin_fact.lstg_site_id = test_sites.site_id
  where test_cal_dt.week_beg_dt between DATE '2013-09-01' and DATE '2013-10-01' and (lstg_format_name='FP-GTC' or 'a' = 'b')
- group by test_cal_dt.week_beg_dt
\ No newline at end of file
+ group by test_cal_dt.week_beg_dt

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/a01c2132/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