Compare commits

..
Author SHA1 Message Date
Trafalgar 2151860a07 add new datax logo 2022-06-20 15:15:03 +08:00
Trafalgar ecfb262ab5 Merge pull request #1388 from VVeaker/patch-1
Update mysqlreader.md
2022-06-20 15:11:14 +08:00
ZhangLu fb49769018 Update mysqlreader.md
mysqlReader在配置querySql和table时会提示两者冲突,配置其一即可
2022-06-02 09:12:17 +08:00
8 changed files with 8 additions and 8 deletions
Binary file not shown.

After

Width:  |  Height:  |  Size: 102 KiB

+2 -2
View File
@@ -197,9 +197,9 @@ MysqlReader插件实现了从Mysql读取数据。在底层实现上,MysqlReade
* **querySql**
* 描述:在有些业务场景下,where这一配置项不足以描述所筛选的条件,用户可以通过该配置型来自定义筛选SQL。当用户配置了这一项之后,DataX系统就会忽略tablecolumn这些配置型,直接使用这个配置项的内容对数据进行筛选,例如需要进行多表join后同步数据,使用select a,b from table_a join table_b on table_a.id = table_b.id <br />
* 描述:在有些业务场景下,where这一配置项不足以描述所筛选的条件,用户可以通过该配置型来自定义筛选SQL。当用户配置了这一项之后,DataX系统就会忽略column这些配置型,直接使用这个配置项的内容对数据进行筛选,例如需要进行多表join后同步数据,使用select a,b from table_a join table_b on table_a.id = table_b.id <br />
`当用户配置querySql时,MysqlReader直接忽略table、column、where条件的配置`querySql优先级大于table、column、where选项。
`当用户配置querySql时,MysqlReader直接忽略column、where条件的配置`querySql优先级大于column、where选项。querySql和table不能同时存在
* 必选:否 <br />
+1 -1
View File
@@ -25,7 +25,7 @@
<commons-io.version>2.4</commons-io.version>
<!-- json -->
<fastjson.version>1.2.83</fastjson.version>
<fastjson.version>1.2.28</fastjson.version>
<!-- opentsdb -->
<opentsdb.version>2.3.2</opentsdb.version>
+1 -1
View File
@@ -22,7 +22,7 @@
<commons-lang3-version>3.3.2</commons-lang3-version>
<commons-configuration-version>1.10</commons-configuration-version>
<commons-cli-version>1.2</commons-cli-version>
<fastjson-version>1.2.83</fastjson-version>
<fastjson-version>1.2.49</fastjson-version>
<guava-version>16.0.1</guava-version>
<diamond.version>3.7.2.1-SNAPSHOT</diamond.version>
+1 -1
View File
@@ -32,7 +32,7 @@
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.83</version>
<version>1.2.78</version>
</dependency>
<dependency>
+1 -1
View File
@@ -23,7 +23,7 @@
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.83</version>
<version>1.2.78</version>
</dependency>
<dependency>
+1 -1
View File
@@ -25,7 +25,7 @@
<commons-io.version>2.4</commons-io.version>
<!-- json -->
<fastjson.version>1.2.83</fastjson.version>
<fastjson.version>1.2.28</fastjson.version>
<!-- test -->
<junit4.version>4.13.1</junit4.version>
+1 -1
View File
@@ -25,7 +25,7 @@
<commons-io.version>2.4</commons-io.version>
<!-- json -->
<fastjson.version>1.2.83</fastjson.version>
<fastjson.version>1.2.28</fastjson.version>
<!-- test -->
<junit4.version>4.13.1</junit4.version>