This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 2266da12483 update
2266da12483 is described below
commit 2266da124831c63616484ac7c2619be49214df29
Author: jiafeng.zhang <zhang...@gmail.com>
AuthorDate: Thu Nov 3 18:14:54 2022 +0800
update
---
docs/ecosystem/datax.md | 59 +++++++++++++---------
.../current/ecosystem/datax.md | 59 +++++++++++++---------
2 files changed, 68 insertions(+), 50 deletions(-)
diff --git a/docs/ecosystem/datax.md b/docs/ecosystem/datax.md
index 1c19e9f8155..89c3c4e89ed 100644
--- a/docs/ecosystem/datax.md
+++ b/docs/ecosystem/datax.md
@@ -145,49 +145,58 @@ PROPERTIES (
3.Create datax script
-```
+```json
{
"job": {
- "setting": {
- "speed": {
- "channel": 1
- },
- "errorLimit": {
- "record": 0,
- "percentage": 0
- }
- },
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
- "username": "xxx",
- "password": "xxx",
"column":
["id","order_code","line_code","remark","unit_no","unit_name","price"],
- "connection": [ { "table": [ "t_test" ], "jdbcUrl": [
"jdbc:mysql://10.10.10.1:33306/demo" ] } ] }
+ "connection": [
+ {
+ "jdbcUrl":
["jdbc:mysql://localhost:3306/demo"],
+ "table": ["employees_1"]
+ }
+ ],
+ "username": "root",
+ "password": "xxxxx",
+ "where": ""
+ }
},
"writer": {
"name": "doriswriter",
"parameter": {
- "feLoadUrl": ["127.0.0.1:8030","127.0.0.2:8030"],
- "beLoadUrl":
["127.0.0.3:8040","127.0.0.4:8040","127.0.0.5:8040"],
- "jdbcUrl": "jdbc:mysql://127.0.0.1:9030/",
- "database": "demo",
- "table": "ods_t_test",
+ "loadUrl": ["127.0.0.1:8030"],
+ "loadProps": {
+ },
"column":
["id","order_code","line_code","remark","unit_no","unit_name","price"],
- "username": "xxx",
- "password": "xxx",
- "postSql": [],
+ "username": "root",
+ "password": "xxxxxx",
+ "postSql": ["select count(1) from all_employees_info"],
"preSql": [],
+ "flushInterval":30000,
+ "connection": [
+ {
+ "jdbcUrl": "jdbc:mysql://127.0.0.1:9030/demo",
+ "selectedDatabase": "demo",
+ "table": ["all_employees_info"]
+ }
+ ],
"loadProps": {
- },
- "maxBatchRows" : 300000,
- "maxBatchByteSize" : 20971520
+ "format": "json",
+ "strip_outer_array": true
+ }
}
}
}
- ]
+ ],
+ "setting": {
+ "speed": {
+ "channel": "1"
+ }
+ }
}
}
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/datax.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/datax.md
index 1497038c3c4..64da955b4aa 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/datax.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/datax.md
@@ -145,49 +145,58 @@ PROPERTIES (
3.创建datax脚本
-```
+```json
{
"job": {
- "setting": {
- "speed": {
- "channel": 1
- },
- "errorLimit": {
- "record": 0,
- "percentage": 0
- }
- },
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
- "username": "xxx",
- "password": "xxx",
"column":
["id","order_code","line_code","remark","unit_no","unit_name","price"],
- "connection": [ { "table": [ "t_test" ], "jdbcUrl": [
"jdbc:mysql://10.10.10.1:33306/demo" ] } ] }
+ "connection": [
+ {
+ "jdbcUrl":
["jdbc:mysql://localhost:3306/demo"],
+ "table": ["employees_1"]
+ }
+ ],
+ "username": "root",
+ "password": "xxxxx",
+ "where": ""
+ }
},
"writer": {
"name": "doriswriter",
"parameter": {
- "feLoadUrl": ["127.0.0.1:8030","127.0.0.2:8030"],
- "beLoadUrl":
["127.0.0.3:8040","127.0.0.4:8040","127.0.0.5:8040"],
- "jdbcUrl": "jdbc:mysql://127.0.0.1:9030/",
- "database": "demo",
- "table": "ods_t_test",
+ "loadUrl": ["127.0.0.1:8030"],
+ "loadProps": {
+ },
"column":
["id","order_code","line_code","remark","unit_no","unit_name","price"],
- "username": "xxx",
- "password": "xxx",
- "postSql": [],
+ "username": "root",
+ "password": "xxxxxx",
+ "postSql": ["select count(1) from all_employees_info"],
"preSql": [],
+ "flushInterval":30000,
+ "connection": [
+ {
+ "jdbcUrl": "jdbc:mysql://127.0.0.1:9030/demo",
+ "selectedDatabase": "demo",
+ "table": ["all_employees_info"]
+ }
+ ],
"loadProps": {
- },
- "maxBatchRows" : 300000,
- "maxBatchByteSize" : 20971520
+ "format": "json",
+ "strip_outer_array": true
+ }
}
}
}
- ]
+ ],
+ "setting": {
+ "speed": {
+ "channel": "1"
+ }
+ }
}
}
```
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
