This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 0baa00af1591880d297c5c3ec548cbf6039de4d9
Author: echo-dundun <50286010+echo-...@users.noreply.github.com>
AuthorDate: Thu Mar 7 10:33:30 2024 +0800
[type](doc) Standardize the name in the sql-dialect document and modify the
format (#31636)
---
docs/en/docs/lakehouse/sql-dialect.md | 44 ++++++++++++++++--------------
docs/zh-CN/docs/lakehouse/sql-dialect.md | 46 +++++++++++++++++---------------
2 files changed, 49 insertions(+), 41 deletions(-)
diff --git a/docs/en/docs/lakehouse/sql-dialect.md
b/docs/en/docs/lakehouse/sql-dialect.md
index c6716205583..e3b16299d2d 100644
--- a/docs/en/docs/lakehouse/sql-dialect.md
+++ b/docs/en/docs/lakehouse/sql-dialect.md
@@ -28,32 +28,46 @@ under the License.
Starting from version 2.1, Doris can support multiple SQL dialects, such as
Presto, Trino, Hive, PostgreSQL, Spark, Oracle, Clickhouse, and more. Through
this feature, users can directly use the corresponding SQL dialect to query
data in Doris, which facilitates users to smoothly migrate their original
business to Doris.
-> 1. This function is currently an experimental function. If you encounter any
problems during use, you are welcome to provide feedback through the mail
group, [Github issue](https://github.com/apache/doris/issues), etc. .
+> 1. This function is currently an experimental function. If you encounter any
problems during use, you are welcome to provide feedback through the mail
group, [GitHub issue](https://github.com/apache/doris/issues), etc. .
>
> 2. This function only supports query statements and does not support other
> DDL and DML statements including Explain.
## Deploy service
-1. Download latest [SQL Transform
Tool](https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/transform-doris-tool/transform-doris-tool-1.0.0-bin-x86).
+1. Download latest [Doris SQL
Convertor](https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/transform-doris-tool/transform-doris-tool-1.0.0-bin-x86).
2. On any FE node, start the service through the following command:
- `nohup ./transform-doris-tool-1.0.0-bin-x86 run --host=0.0.0.0
--port=5001 &`
+ `nohup ./doris-sql-convertor-1.0.1-bin-x86 run --host=0.0.0.0
--port=5001 &`
- > 1. This service is a stateless service and can be started and stopped
at any time.
- >
- > 2. `5001` is the service port and can be arbitrarily specified as an
available port.
- >
- > 3. It is recommended to start a separate service on each FE node.
+ :::note
+ 1. This service is a stateless service and can be started and stopped
at any time.
+
+ 2. `5001` is the service port and can be arbitrarily specified as an
available port.
+
+ 3. It is recommended to start a separate service on each FE node.
+ :::
3. Start the Doris cluster (version 2.1 or higher)
4. Set the URL of the SQL Dialect Conversion Service with the following
command in Doris:
`MySQL> set global sql_converter_service_url =
"http://127.0.0.1:5001/api/v1/convert"`
-
- > 1. `127.0.0.1:5001` is the deployment node IP and port of the SQL
dialect conversion service.
+
+ :::note
+ 1. `127.0.0.1:5001` is the deployment node IP and port of the SQL
dialect conversion service.
+ :::
## Use SQL dialect
+Currently supported dialect types include:
+
+- `presto`
+- `trino`
+- `hive`
+- `spark`
+- `postgres`
+- `clickhouse`
+- `oracle`
+
example:
- Presto
@@ -113,13 +127,3 @@ mysql> select toString(start_time) as col1,
1 row in set (0.04 sec)
```
-Currently supported dialect types include:
-
-- `presto`
-- `trino`
-- `hive`
-- `spark`
-- `postgres`
-- `clickhouse`
-- `oracle`
-
diff --git a/docs/zh-CN/docs/lakehouse/sql-dialect.md
b/docs/zh-CN/docs/lakehouse/sql-dialect.md
index 3b731b949da..3475c8dfe4f 100644
--- a/docs/zh-CN/docs/lakehouse/sql-dialect.md
+++ b/docs/zh-CN/docs/lakehouse/sql-dialect.md
@@ -28,32 +28,45 @@ under the License.
从 2.1 版本开始，Doris 可以支持多种 SQL 方言，如 Presto、Trino、Hive、PostgreSQL、Spark、Clickhouse
等等。通过这个功能，用户可以直接使用对应的 SQL 方言查询 Doris 中的数据，方便用户将原先的业务平滑的迁移到 Doris 中。
-> 1. 该功能目前是实验性功能，您在使用过程中如遇到任何问题，欢迎通过邮件组、[Github
issue](https://github.com/apache/doris/issues) 等方式进行反馈。
+> 1. 该功能目前是实验性功能，您在使用过程中如遇到任何问题，欢迎通过邮件组、[GitHub
issue](https://github.com/apache/doris/issues) 等方式进行反馈。
>
-> 2. 该功能只支持查询语句，不支持包括 Explain 在内的其他 DDL、DML 语句。
+> 2. 该功能只支持查询语句，不支持 DDL、DML 语句。
## 部署服务
1. 下载最新版本的 [SQL
方言转换工具](https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/transform-doris-tool/transform-doris-tool-1.0.0-bin-x86)。
-2. 在任意FE节点，通过以下命令启动服务：
+2. 在任意 FE 节点，通过以下命令启动服务：
- `nohup ./transform-doris-tool-1.0.0-bin-x86 run --host=0.0.0.0
--port=5001 &`
+ `nohup ./doris-sql-convertor-1.0.1-bin-x86 run --host=0.0.0.0
--port=5001 &`
- > 1. 该服务是一个无状态的服务，可随时启停。
- >
- > 2. `5001` 是服务端口，可以任意指定为一个可用端口。
- >
- > 3. 建议在每个 FE 节点都单独启动一个服务。
+ :::note
+ 1. 该服务是一个无状态的服务，可随时启停。
+
+ 2. `5001` 是服务端口，可以任意指定为一个可用端口。
+
+ 3. 建议在每个 FE 节点都单独启动一个服务。
+ :::
3. 启动 Doris 集群（2.1 或更高版本）
-4. 通过以下命令，在Doris中设置 SQL 方言转换服务的 URL：
+4. 通过以下命令，在 Doris 中设置 SQL 方言转换服务的 URL：
`MySQL> set global sql_converter_service_url =
"http://127.0.0.1:5001/api/v1/convert"`
-
- > 1. `127.0.0.1:5001` 是 SQL 方言转换服务的部署节点 ip 和端口。
+
+ :::note
+ 1. `127.0.0.1:5001` 是 SQL 方言转换服务的部署节点 ip 和端口。
+ :::
## 使用 SQL 方言
+目前支持的方言类型包括：
+
+- `presto`
+- `trino`
+- `hive`
+- `spark`
+- `postgres`
+- `clickhouse`
+
示例:
- Presto
@@ -113,12 +126,3 @@ mysql> select toString(start_time) as col1,
1 row in set (0.04 sec)
```
-目前支持的方言类型包括：
-
-- `presto`
-- `trino`
-- `hive`
-- `spark`
-- `postgres`
-- `clickhouse`
-
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
