LeeSmallNorth opened a new issue, #10661:
URL: https://github.com/apache/seatunnel/issues/10661
各种404的链接,各种过时的脚本配置,照着官网,一天没能同步一次成功的数据,脚本怎么写都不对,我真没时间陪你们胡闹了。
就mysql写到mysql,这个简单的操作
`env {
execution.parallelism = 1
job.mode = "BATCH"
}
source {
jdbc {
url =
"jdbc:mysql://192.168.1.11:3306/ceshi?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true"
driver = "com.mysql.cj.jdbc.Driver"
username = "root"
password = "szls@123"
query = "select id,name,age,city from user where age >= 18"
plugin_output = "source_mysql_data"
}
}
sink {
jdbc {
plugin_input = "source_mysql_data"
url =
"jdbc:mysql://192.168.1.11:3306/ceshi?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true"
driver = "com.mysql.cj.jdbc.Driver"
username = "root"
password = "szls@123"
table = "user_result"
}
}`
souce中jdbc 不能写成Jdbc,报错!!!!
sink中jdbc,用户名叫user
<img width="1338" height="503" alt="Image"
src="https://github.com/user-attachments/assets/981ab6e1-ee4f-44ce-9049-71fdfe34d90d"
/>
mysql中用户名叫username
<img width="1455" height="535" alt="Image"
src="https://github.com/user-attachments/assets/5343725f-b6b8-468a-8f37-d510a7d53704"
/>
既然mysql用的也是jdbc连接器,为啥没统一!!!!
厉害的来了
sink不认jdbc,也不认mysql运行就报错
<img width="3360" height="273" alt="Image"
src="https://github.com/user-attachments/assets/aeed2285-199a-498c-9ac6-afb6f7a8607e"
/>
第二步 generate_sink_sql非必填,运行还是报错
<img width="1115" height="385" alt="Image"
src="https://github.com/user-attachments/assets/6d688c9d-425f-452b-bd33-bae31fdeb3c3"
/>
<img width="3320" height="850" alt="Image"
src="https://github.com/user-attachments/assets/90a74cf0-d564-4c02-835b-7f3e63f6ba07"
/>
我一下午就研究这一个破方法都没通,求求你们了,能不能好好整理一下官方文档
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]