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
The following commit(s) were added to refs/heads/document by this push:
new 319b1da Optimize pushdown document
319b1da is described below
commit 319b1da89138c322e728478e9aa217d573037d9d
Author: yaqian.zhang <[email protected]>
AuthorDate: Mon Aug 17 10:48:39 2020 +0800
Optimize pushdown document
---
website/_docs/tutorial/query_pushdown.cn.md | 12 ++++++++----
website/_docs/tutorial/query_pushdown.md | 8 +++++++-
2 files changed, 15 insertions(+), 5 deletions(-)
diff --git a/website/_docs/tutorial/query_pushdown.cn.md
b/website/_docs/tutorial/query_pushdown.cn.md
index bcef61e..82b66a1 100644
--- a/website/_docs/tutorial/query_pushdown.cn.md
+++ b/website/_docs/tutorial/query_pushdown.cn.md
@@ -15,8 +15,8 @@ since: v2.1
#### 下压至单个引擎
以Hive为例说明开启步骤
-1. 修改配置文件`kylin.properties`打开Query
Pushdown注释掉的配置项`kylin.query.pushdown.runner-class-name`，设置为`org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl`
-
+1. 修改配置文件`kylin.properties`打开Query
Pushdown注释掉的配置项`kylin.query.pushdown.runner-class-name`，设置为`org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl`；
+如果你需要将查询下压到presto，请将这项配置设置为`org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl`，其余配置参见本页末尾的[Pushdown
to Presto](#pushdown-to-presto)中的介绍。
2.
在配置文件`kylin.properties`添加如下配置项。若不设置，将使用默认配置项。请不要忘记将"hiveserver"和"10000"替换成环境中Hive运行的主机和端口。
@@ -40,7 +40,9 @@ since: v2.1
{% endhighlight %}
-然后，重启Kylin
+3. 当 Pushdown 到的查询引擎不是`Hive` 时，请将对应查询引擎的 JDBC 驱动放在 $KYLIN_HOME/ext
目录下，没有此目录时请自行创建。
+
+然后，重启Kylin。
#### 下压至多个引擎
自 v3.0.0 起，开始支持通过JDBC下压至多个引擎进行查询。
@@ -98,4 +100,6 @@ kylin.query.pushdown.jdbc.url={YOUR_URL}
kylin.query.pushdown.jdbc.driver=com.facebook.presto.jdbc.PrestoDriver
kylin.query.pushdown.jdbc.username={USER_NAME}
kylin.query.pushdown.jdbc.password={PASSWORD}
-{% endhighlight %}
\ No newline at end of file
+{% endhighlight %}
+
+并且，请自行下载 Presto 的 JDBC 驱动 presto-jdbc-xxx.jar 放置在 $KYLIN_HOME/ext
目录下，没有此目录时请自行创建。
\ No newline at end of file
diff --git a/website/_docs/tutorial/query_pushdown.md
b/website/_docs/tutorial/query_pushdown.md
index 5d22b43..2c0426d 100644
--- a/website/_docs/tutorial/query_pushdown.md
+++ b/website/_docs/tutorial/query_pushdown.md
@@ -14,8 +14,10 @@ If a query can not be answered by any cube, Kylin supports
pushing down such que
### Query Pushdown config
#### Pushdown to single engine
-1. In Kylin's installation directory, uncomment configuration item
`kylin.query.pushdown.runner-class-name` of config file `kylin.properties`, and
set it to `org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl`
+Take hive as an example to explain the opening steps:
+1. In Kylin's installation directory, uncomment configuration item
`kylin.query.pushdown.runner-class-name` of config file `kylin.properties`, and
set it to `org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl`,
+If you need to pushdown the query to presto, please set this configuration to
`org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl`. For other
configurations, please refer to [Pushdown to Presto](#pushdown-to-presto) at
the end of this page.
2. Add configuration items below in config file `kylin.properties`.
@@ -35,6 +37,8 @@ If a query can not be answered by any cube, Kylin supports
pushing down such que
Here is a sample configuration; remember to change host "hiveserver" and port
"10000" with your cluster configuraitons.
+3. When the query engine pushdown to is not `Hive`, please put the jdbc driver
of the corresponding query engine in $KYLIN_HOME/ext directory, if there is no
such directory, please create it yourself.
+
Then, restart Kylin.
{% highlight Groff markup %}
@@ -108,3 +112,5 @@
kylin.query.pushdown.jdbc.driver=com.facebook.presto.jdbc.PrestoDriver
kylin.query.pushdown.jdbc.username={USER_NAME}
kylin.query.pushdown.jdbc.password={PASSWORD}
{% endhighlight %}
+
+In addition, please download Presto jdbc driver presto-jdbc-xxx.jar and put it
in $KYLIN_HOME/ext directory, if there is no such directory, please create it
yourself.
\ No newline at end of file
