This is an automated email from the ASF dual-hosted git repository.
xxyu pushed a commit to branch document
in repository https://gitbox.apache.org/repos/asf/kylin.git
commit 9da45c008c5c537985541ad42f5a2e9ad8aa5f53
Author: XiaoxiangYu <hit_la...@126.com>
AuthorDate: Mon Jun 8 22:00:46 2020 +0800
Update document for KYLIN-3361 KYLIN-4312
---
website/_docs31/howto/howto_use_restapi.cn.md | 1 +
website/_docs31/howto/howto_use_restapi.md | 1 +
website/_docs31/tutorial/query_pushdown.cn.md | 2 +-
website/_docs31/tutorial/query_pushdown.md | 2 +-
website/_docs31/tutorial/sql_reference.cn.md | 19 +++++++++++++++++++
website/_docs31/tutorial/sql_reference.md | 18 ++++++++++++++++++
website/_docs31/tutorial/web.cn.md | 4 ++--
website/_docs31/tutorial/web.md | 4 ++--
.../Kylin-Web-Tutorial/insight-query-part.png | Bin 0 -> 42636 bytes
9 files changed, 45 insertions(+), 6 deletions(-)
diff --git a/website/_docs31/howto/howto_use_restapi.cn.md
b/website/_docs31/howto/howto_use_restapi.cn.md
index 803a785..5e402a4 100644
--- a/website/_docs31/howto/howto_use_restapi.cn.md
+++ b/website/_docs31/howto/howto_use_restapi.cn.md
@@ -119,6 +119,7 @@ curl -X PUT --user ADMIN:KYLIN -H "Content-Type:
application/json;charset=utf-8"
* limit - `optional` `int` Query limit. If limit is set in sql, perPage will
be ignored.
* acceptPartial - `optional` `bool` Whether accept a partial result or not,
default be "false". Set to "false" for production use.
* project - `optional` `string` Project to perform query. Default value is
'DEFAULT'.
+* backdoorToggles - `optional` `map` You can set a key/value pair
(`"DEBUG_TOGGLE_HIT_CUBE":"SimpleCube_01"`) to specific cube for your query.
Default is empty map.
#### Request Sample
diff --git a/website/_docs31/howto/howto_use_restapi.md
b/website/_docs31/howto/howto_use_restapi.md
index 78672dd..6997a8a 100644
--- a/website/_docs31/howto/howto_use_restapi.md
+++ b/website/_docs31/howto/howto_use_restapi.md
@@ -119,6 +119,7 @@ curl -X PUT --user ADMIN:KYLIN -H "Content-Type:
application/json;charset=utf-8"
* limit - `optional` `int` Query limit. If limit is set in sql, perPage will
be ignored.
* acceptPartial - `optional` `bool` Whether accept a partial result or not,
default be "false". Set to "false" for production use.
* project - `optional` `string` Project to perform query. Default value is
'DEFAULT'.
+* backdoorToggles - `optional` `map` You can set a key value pair
(`"DEBUG_TOGGLE_HIT_CUBE":"SimpleCube_01"`) to specific cube for your query.
Default is empty map.
#### Request Sample
diff --git a/website/_docs31/tutorial/query_pushdown.cn.md
b/website/_docs31/tutorial/query_pushdown.cn.md
index 817ce1b..51148bc 100644
--- a/website/_docs31/tutorial/query_pushdown.cn.md
+++ b/website/_docs31/tutorial/query_pushdown.cn.md
@@ -91,7 +91,7 @@ kylin.query.pushdown.id1.jdbc.pool-min-idle
如果你希望查询下压到Presto，你可以在 Project 级别配置以下参数以启用 Presto 查询下压 (通过 KYLIN-4491 引入)。
{% highlight Groff markup %}
-kylin.query.pushdown.runner-class-name=org.apache.kylin.query.pushdown.PushDownRunnerOtherImpl
+kylin.query.pushdown.runner-class-name=org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl
kylin.source.jdbc.dialect=presto
kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.PrestoAdaptor
kylin.query.pushdown.jdbc.url={YOUR_URL}
diff --git a/website/_docs31/tutorial/query_pushdown.md
b/website/_docs31/tutorial/query_pushdown.md
index 107c79d..e96fec3 100644
--- a/website/_docs31/tutorial/query_pushdown.md
+++ b/website/_docs31/tutorial/query_pushdown.md
@@ -100,7 +100,7 @@ If query is answered by backup engine, `Is Query Push-Down`
is set to `true` in
If you want your query be push down to Presto, you can set following
configuration in Project level properties (Introduced in KYLIN-4491).
{% highlight Groff markup %}
-kylin.query.pushdown.runner-class-name=org.apache.kylin.query.pushdown.PushDownRunnerOtherImpl
+kylin.query.pushdown.runner-class-name=org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl
kylin.source.jdbc.dialect=presto
kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.PrestoAdaptor
kylin.query.pushdown.jdbc.url={YOUR_URL}
diff --git a/website/_docs31/tutorial/sql_reference.cn.md
b/website/_docs31/tutorial/sql_reference.cn.md
index 2cd53a0..01912b6 100644
--- a/website/_docs31/tutorial/sql_reference.cn.md
+++ b/website/_docs31/tutorial/sql_reference.cn.md
@@ -46,6 +46,7 @@ Apache Kylin 使用 Apache Calcite 做 SQL 解析和优化。作为一款 OLAP
[SUSTRING](#SUBSTRING)
[COALESCE](#COALESCE)
+[STDDEV_SUM](#STDDEV_SUM)
## 数据类型
[数据类型](#datatype)
@@ -374,6 +375,24 @@ SELECT SUBSTRING(lstg_format_name, 1) FROM kylin_sales;
SELECT COALESCE(lstg_format_name, '888888888888') FROM kylin_sales;
{% endhighlight %}
+## [STDDEV_SUM](#STDDEV_SUM)
+例子: 第一个查询和第二个查询是对等的，```stddev_sum``` 是一个在 KYLIN-3361 引入的 UDAF。
+{% highlight Groff markup %}
+select A, stddev_sum(sampling_dim, m)
+from T
+group by A
+{% endhighlight %}
+
+{% highlight Groff markup %}
+select A, stddev(SUM_M)
+from (
+ select A, sampling_dim, sum(m) as SUM_M
+ from T
+ group by A, sampling_dim
+) a
+group by A
+{% endhighlight %}
+
## 数据类型 {#datatype}
| ---------- | ---------- | ---------- | ---------- | -------------------- |
diff --git a/website/_docs31/tutorial/sql_reference.md
b/website/_docs31/tutorial/sql_reference.md
index 748ecf1..ffe6032 100644
--- a/website/_docs31/tutorial/sql_reference.md
+++ b/website/_docs31/tutorial/sql_reference.md
@@ -45,6 +45,7 @@ Apache Kylin relies on Apache Calcite to parse and optimize
the SQL statements.
[CAST](#CAST)
[SUSTRING](#SUBSTRING)
[COALESCE](#COALESCE)
+[STDDEV_SUM](#STDDEV_SUM)
## Data Type
@@ -377,6 +378,23 @@ Example:
SELECT COALESCE(lstg_format_name, '888888888888') FROM kylin_sales;
{% endhighlight %}
+## [STDDEV_SUM](#STDDEV_SUM)
+Example: The first query is shortcut of the second query. ```stddev_sum``` is
a UDAF which introduced in KYLIN-3361.
+{% highlight Groff markup %}
+select A, stddev_sum(sampling_dim, m)
+from T
+group by A
+{% endhighlight %}
+
+{% highlight Groff markup %}
+select A, stddev(SUM_M)
+from (
+ select A, sampling_dim, sum(m) as SUM_M
+ from T
+ group by A, sampling_dim
+) a
+group by A
+{% endhighlight %}
## DATA TYPE {#DATATYPE}
diff --git a/website/_docs31/tutorial/web.cn.md
b/website/_docs31/tutorial/web.cn.md
index e6b96c7..57a00bf 100644
--- a/website/_docs31/tutorial/web.cn.md
+++ b/website/_docs31/tutorial/web.cn.md
@@ -48,9 +48,9 @@ Kylin 的网页版为用户提供了一个简单的查询工具来运行 SQL 以
>
> 2. 支持聚合函数和 group by
-由菜单栏进入 “Insight” 页面：
+由菜单栏进入 “Insight” 页面：你可以在 **Cube** 下拉框选择你希望查询击中的 Cube。
-
+
* 源表：
diff --git a/website/_docs31/tutorial/web.md b/website/_docs31/tutorial/web.md
index a5e3c13..2856671 100644
--- a/website/_docs31/tutorial/web.md
+++ b/website/_docs31/tutorial/web.md
@@ -45,9 +45,9 @@ Kylin's web offer a simple query tool for user to run SQL to
explore existing cu
>
> 2. Aggregation function and GROUP BY are supported
-Go to "Insight" menu.
+Go to "Insight" menu. You can specific cube for your query in **Cube**
DropDownList .
-
+
* Source Tables:
diff --git a/website/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png
b/website/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png
new file mode 100644
index 0000000..28f1192
Binary files /dev/null and
b/website/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png differ
