env {
job.mode = "BATCH" #标记是批处理还是流处理
execution.parallelism = 1 #source/sink的并行度,按需配置
job.name = "core_dept_load" #任务名称
}
source {
# 示例:MySQL 源配置
Jdbc {
url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC"
driver = "com.mysql.cj.jdbc.Driver"
username = "root"
password = "123456"
table_path = "test.students"
}
}
sink {
Console {
}
}
jdbc 的jar包,connector 目录下需要有connector-jdbc-2.3.12-2.12.15.jar包
[root@localhost hndata]# ll seatunnel/connectors/
total 34492
-rw-r--r--. 1 root root 27350133 Nov 8 2023 connector-cdc-base-2.3.12.jar
-rw-r--r--. 1 root root 231324 Nov 8 2023 connector-console-2.3.12.jar
-rw-r--r--. 1 root root 3580486 Nov 24 19:06 connector-doris-2.3.12.jar
-rw-r--r--. 1 root root 382141 Nov 8 2023 connector-fake-2.3.12.jar
-rw-r--r--. 1 root root 1289543 Nov 24 19:23 connector-jdbc-2.3.12-2.12.15.jar
-rw-r--r--. 1 root root 2462364 Nov 27 01:14 mysql-connector-java-8.0.26.jar
-rw-r--r--. 1 root root 7108 Nov 8 2023 plugin-mapping.properties
[root@localhost hndata]# ll seatunnel/lib/
total 193976
-rw-r--r--. 1 root root 2462364 Nov 26 20:52 mysql-connector-java-8.0.26.jar
-rw-r--r--. 1 root root 43209805 Nov 8 2023 seatunnel-hadoop3-3.1.4-uber.jar
-rw-r--r--. 1 root root 86818044 Nov 8 2023 seatunnel-hadoop-aws.jar
-rw-r--r--. 1 root root 66131549 Nov 8 2023 seatunnel-transforms-v2.jar