[kylin] 07/08: KYLIN-4704 Add 'PERCENTILE' measure for sample metadata

[xxyu]

This is an automated email from the ASF dual-hosted git repository.

xxyu pushed a commit to branch kylin-on-parquet-v2
in repository https://gitbox.apache.org/repos/asf/kylin.git

commit ea267e240a9584cbefccd935d14f702c1f58c291
Author: Zhichao Zhang <441586...@qq.com>
AuthorDate: Wed Aug 26 23:40:36 2020 +0800

    KYLIN-4704 Add 'PERCENTILE' measure for sample metadata
---
 .../template/cube_desc/kylin_sales_cube.json       | 23 ++++++++++++++++++++--
 1 file changed, 21 insertions(+), 2 deletions(-)

diff --git a/examples/sample_cube/template/cube_desc/kylin_sales_cube.json 
b/examples/sample_cube/template/cube_desc/kylin_sales_cube.json
index 8042caa..4c970c5 100644
--- a/examples/sample_cube/template/cube_desc/kylin_sales_cube.json
+++ b/examples/sample_cube/template/cube_desc/kylin_sales_cube.json
@@ -192,6 +192,24 @@
         },
         "returntype": "bitmap"
       }
+  }, {
+    "name" : "PRICE_PERCENTILE",
+    "function" : {
+      "expression" : "PERCENTILE_APPROX",
+      "parameter" : {
+        "type" : "column",
+        "value" : "KYLIN_SALES.PRICE"
+      },
+      "returntype" : "percentile(100)"
+    }
+  }
+  ],
+  "dictionaries": [
+    {
+      "column": "KYLIN_SALES.ITEM_ID",
+      "builder": "org.apache.kylin.dict.GlobalDictionaryBuilder",
+      "cube": null,
+      "model": null
     }
   ],
   "rowkey" : {
@@ -200,7 +218,8 @@
       "encoding" : "integer:4"
     }, {
       "column" : "SELLER_ID",
-      "encoding" : "integer:4"
+      "encoding" : "integer:4",
+      "isShardBy" : true
     }, {
       "column" : "TRANS_ID",
       "encoding" : "integer:4"
@@ -262,7 +281,7 @@
       "name" : "F2",
       "columns" : [ {
         "qualifier" : "M",
-        "measure_refs" : [ "SELLER_CNT_HLL", "TOP_SELLER", "ITEM_BITMAP" ]
+        "measure_refs" : [ "SELLER_CNT_HLL", "TOP_SELLER", "ITEM_BITMAP", 
"PRICE_PERCENTILE" ]
       } ]
     } ]
   },