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.git
The following commit(s) were added to refs/heads/master by this push:
new e48b691139 Failed to get doris_odbc_name value in mysql_to_doris,
replace driver value error (#11965)
e48b691139 is described below
commit e48b6911393763f32ad2e92a91c43ec425aa4738
Author: caoliang-web <71004656+caoliang-...@users.noreply.github.com>
AuthorDate: Mon Aug 29 19:13:54 2022 +0800
Failed to get doris_odbc_name value in mysql_to_doris, replace driver value
error (#11965)
Failed to get doris_odbc_name value in mysql_to_doris, replace driver value
error
---
docs/en/docs/ecosystem/mysql-to-doris.md | 2 ++
docs/zh-CN/docs/ecosystem/mysql-to-doris.md | 12 ++++++++----
extension/mysql_to_doris/all_tables.sh | 2 +-
extension/mysql_to_doris/conf/doris.conf | 2 +-
extension/mysql_to_doris/user_define_tables.sh | 2 +-
5 files changed, 13 insertions(+), 7 deletions(-)
diff --git a/docs/en/docs/ecosystem/mysql-to-doris.md
b/docs/en/docs/ecosystem/mysql-to-doris.md
index 51605d72d9..67afcd1f9d 100644
--- a/docs/en/docs/ecosystem/mysql-to-doris.md
+++ b/docs/en/docs/ecosystem/mysql-to-doris.md
@@ -69,6 +69,7 @@ mysql to doris code
[here](https://github.com/apache/doris/tree/master/extension
master_host=
master_port=
doris_password=
+ doris_odbc_name=''
#mysql.conf
mysql_host=
@@ -80,6 +81,7 @@ mysql to doris code
[here](https://github.com/apache/doris/tree/master/extension
| master_host | Doris FE master node IP |
| master_port | Doris FE query_port port |
| doris_password | Doris Password (default root user) |
+ | doris_odbc_name | The name of mysql odbc in the odbcinst.ini
configuration file under be/conf |
| mysql_host | Mysql IP |
| mysql_password | Mysql Password (default root user) |
diff --git a/docs/zh-CN/docs/ecosystem/mysql-to-doris.md
b/docs/zh-CN/docs/ecosystem/mysql-to-doris.md
index cc89126eb2..56a5bb7891 100644
--- a/docs/zh-CN/docs/ecosystem/mysql-to-doris.md
+++ b/docs/zh-CN/docs/ecosystem/mysql-to-doris.md
@@ -62,6 +62,7 @@ mysql to doris
代码[这里](https://github.com/apache/doris/tree/master/extens
### 全量
1. 下载使用mysql to
doris[这里](https://github.com/apache/doris/tree/master/extension/mysql_to_doris)
+
2. 配置相关文件
```shell
@@ -69,20 +70,23 @@ mysql to doris
代码[这里](https://github.com/apache/doris/tree/master/extens
master_host=
master_port=
doris_password=
+ doris_odbc_name=''
#mysql.conf
mysql_host=
mysql_password=
```
- | 配置项 | 说明 |
- | -------------- | ----------------------- |
- | master_host | Doris FE master节点IP |
+ | 配置项 | 说明 |
+ |------------------| ----------------------- |
+ | master_host | Doris FE master节点IP |
| master_port | Doris FE query_port端口 |
| doris_password | Doris 密码(默认root用户) |
- | mysql_host | Mysql IP |
+ | doris_odbc_name | be/conf 下odbcinst.ini配置文件中mysql odbc的名称 |
+ | mysql_host | Mysql IP |
| mysql_password | Mysql 密码(默认root用户) |
+
3. 执行`all_tables.sh`脚本
```
diff --git a/extension/mysql_to_doris/all_tables.sh
b/extension/mysql_to_doris/all_tables.sh
index e71e31ecef..634ece0f71 100644
--- a/extension/mysql_to_doris/all_tables.sh
+++ b/extension/mysql_to_doris/all_tables.sh
@@ -72,7 +72,7 @@ mv ./files/tables2.sql ./files/tables.sql
#start transform tables struct
sed -i '/ENGINE=/a) ENGINE=ODBC\n COMMENT "ODBC"\nPROPERTIES (\n"host" =
"ApacheDorisHostIp",\n"port" = "3306",\n"user" = "root",\n"password" =
"ApacheDorisHostPassword",\n"database" = "ApacheDorisDataBases",\n"table" =
"ApacheDorisTables",\n"driver" = "MySQL",\n"odbc_type" = "mysql");'
./files/tables.sql
-sed -i "s/\"driver\"=\"MySQL\"/$doris_odbc_name/g" ./files/tables.sql
+sed -i "s/\"driver\" = \"MySQL\"/\"driver\" = \"$doris_odbc_name\"/g"
./files/tables.sql
#delete match line
sed -i '/ENGINT=/d' ./files/tables.sql
diff --git a/extension/mysql_to_doris/conf/doris.conf
b/extension/mysql_to_doris/conf/doris.conf
index 171aed449e..a870906795 100644
--- a/extension/mysql_to_doris/conf/doris.conf
+++ b/extension/mysql_to_doris/conf/doris.conf
@@ -19,4 +19,4 @@
master_host=192.168.0.151
master_port=9030
doris_password=123456
-doris_odbc_name=MySQL ODBC
+doris_odbc_name='MySQL ODBC'
diff --git a/extension/mysql_to_doris/user_define_tables.sh
b/extension/mysql_to_doris/user_define_tables.sh
index 081fdbc486..d65292f5f2 100644
--- a/extension/mysql_to_doris/user_define_tables.sh
+++ b/extension/mysql_to_doris/user_define_tables.sh
@@ -68,7 +68,7 @@ rm -rf ./user_files/tables1.sql
mv ./user_files/tables2.sql ./user_files/tables.sql
#start transform tables struct
sed -i '/ENGINE=/a) ENGINE=ODBC\n COMMENT "ODBC"\nPROPERTIES (\n"host" =
"ApacheDorisHostIp",\n"port" = "3306",\n"user" = "root",\n"password" =
"ApacheDorisHostPassword",\n"database" = "ApacheDorisDataBases",\n"table" =
"ApacheDorisTables",\n"driver" = "MySQL",\n"odbc_type" = "mysql");'
./user_files/tables.sql
-sed -i "s/\"driver\"=\"MySQL\"/$doris_odbc_name/g" ./user_files/tables.sql
+sed -i "s/\"driver\" = \"MySQL\"/\"driver\" = \"$doris_odbc_name\"/g"
./files/tables.sql
#delete match line
sed -i '/ENGINT=/d' ./user_files/tables.sql
sed -i '/PRIMARY KEY/d' ./user_files/tables.sql
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
