You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@inlong.apache.org by GitBox <gi...@apache.org> on 2022/01/17 13:05:37 UTC
[GitHub] [incubator-inlong-website] EMsnap opened a new pull request #254: [INLONG-2169][Feature][Agent] should provide docs for agent db sql collect
EMsnap opened a new pull request #254:
URL: https://github.com/apache/incubator-inlong-website/pull/254
Fixes (https://github.com/apache/incubator-inlong/issues/2169)
### Motivation
should provide docs for agent db sql collect
### Modifications
should provide docs for agent db sql collect
### Verifying this change
- [ ] Make sure that the change passes the CI checks.
### Documentation
- Does this pull request introduce a new feature? (yes / no)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-inlong-website] dockerzhang commented on a change in pull request #254: [INLONG-2169][Feature][Agent] should provide docs for agent db sql collect
Posted by GitBox <gi...@apache.org>.
dockerzhang commented on a change in pull request #254:
URL: https://github.com/apache/incubator-inlong-website/pull/254#discussion_r787298479
##########
File path: i18n/zh-CN/docusaurus-plugin-content-docs/current/modules/agent/sql.md
##########
@@ -0,0 +1,61 @@
+---
+title: SQL
Review comment:
SQL -> MySQL SQL
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-inlong-website] dockerzhang commented on a change in pull request #254: [INLONG-2169][Feature][Agent] should provide docs for agent db sql collect
Posted by GitBox <gi...@apache.org>.
dockerzhang commented on a change in pull request #254:
URL: https://github.com/apache/incubator-inlong-website/pull/254#discussion_r787295380
##########
File path: docs/modules/agent/sql.md
##########
@@ -0,0 +1,61 @@
+---
+title: SQL
Review comment:
SQL -> MySQL SQL
##########
File path: docs/modules/agent/sql.md
##########
@@ -0,0 +1,61 @@
+---
+title: SQL
+sidebar_position: 3
+---
+
+## Preface
Review comment:
Preface -> Overview
##########
File path: i18n/zh-CN/docusaurus-plugin-content-docs/current/modules/agent/sql.md
##########
@@ -0,0 +1,61 @@
+---
+title: SQL
+sidebar_position: 3
+---
+
+## 前言
+目前Agent支持MYSQL版本为5.1.x , 5.5.x , 5.6.x , 5.7.x , 8.0.x
+目前Agent只支持curl请求创建Job方式提交采集任务，暂时不支持manager前端创建SQL采集
+
+
+## Sql Job创建步骤
+
+1、在manager上申请接入，填写数据信息时，选择消息来源为"自主推送"
+2、选择源数据字段分隔符
+3、填写源数据字段，字段顺序与sql查询结果中的字段顺序保持一致
+4、使用curl请求创建一个SQL读取任务
+
+## 参数说明
+
+```
+SQL Agent Job 中各个使用参数说明为
+1、job.sql.command: 实际执行的sql语句，举例: select * from apache_inlong_manager.user
+2、job.sql.user: 连接数据库时使用的user，举例: abc
+3、job.sql.password: 连接数据库时使用的password, 举例: 123456
+4、job.sql.hostname: 连接的数据库ip地址，举例：127.0.0.1
+5、job.sql.port：连接的数据库端口，举例：3306
+6、job.sql.separator: 使用的分割符来分割多个字段，需要与manager前端
+```
+
+## 举例
+
+```bash
+curl --location --request POST 'http://localhost:8008/config/job' \--header 'Content-Type: application/json' \--data '{
+ "job": {
+ "sql": {
+ "command": "select * from apache_inlong_manager.user",
+ "user": "root",
+ "password": "DI@Bigdata#2021",
Review comment:
default password use 'inlong`
##########
File path: docs/modules/agent/sql.md
##########
@@ -0,0 +1,61 @@
+---
+title: SQL
+sidebar_position: 3
+---
+
+## Preface
+Currently, Agent supports MYSQL version 5.1.x , 5.5.x , 5.6.x , 5.7.x , 8.0.x
+Currently, the Agent only supports the curl request to create a Job to submit collection tasks, and temporarily does not support the manager front-end to create SQL collection
+
+
+## Sql Job creation Steps
Review comment:
Create a MySQL Job
##########
File path: i18n/zh-CN/docusaurus-plugin-content-docs/current/modules/agent/sql.md
##########
@@ -0,0 +1,61 @@
+---
+title: SQL
+sidebar_position: 3
+---
+
+## 前言
Review comment:
前言->总览
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-inlong-website] dockerzhang merged pull request #254: [INLONG-2169][Feature][Agent] should provide docs for agent db sql collect
Posted by GitBox <gi...@apache.org>.
dockerzhang merged pull request #254:
URL: https://github.com/apache/incubator-inlong-website/pull/254
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org