import org.apache.flink.api.common.functions.MapFunction;
import org.apache.flink.connector.jdbc.JdbcConnectionOptions;
import org.apache.flink.connector.jdbc.JdbcExecutionOptions;
import org.apache.flink.connector.jdbc.JdbcSink;
import org.apache.flink.streaming.api.datastream.DataStreamSource;
import org.apache.flink.streaming.api.datastream.SingleOutputStreamOperator;
import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;
/**
* Author:panghu
* Date:2022-05-29
* Description: 写数据到mysql
*/
public class _18SinkToMySQLTest {
public static void main(String[] args) throws Exception {
StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
env.setParallelism(1);
DataStreamSource<String> streamSource = env.readTextFile("input/clicks.csv");
// 将字符串封装为Event对象
SingleOutputStreamOperator<Event> mapSource = streamSource.map(new MapFunction<String, Event>() {
@Override
public Event map(String line) throws Exception {
String[] split = line.split(", ");
Event event = new Event(split[0], split[1], Long.valueOf(split[2]));
return event;
}
});
mapSource.addSink(
//参数1:sql
JdbcSink.sink("INSERT INTO clicks(user, url) VALUES (?,?) ",
//参数2:statement占位符
(statement, data) -> {
statement.setString(1, data.user);
statement.setString(2, data.url);
},
//参数3:设置
JdbcExecutionOptions.builder()
.withBatchIntervalMs(200) //批次提交周期:每200ms
.withBatchSize(1000) //批次提交周期:每1000条
.withMaxRetries(5) //批次提交周期,每5次
.build(),
new JdbcConnectionOptions.JdbcConnectionOptionsBuilder()
.withUrl("jdbc:mysql://hadoop102:3306/test") //mysql地址
.withDriverName("com.mysql.jdbc.Driver")
.withUsername("root")
.withPassword("000000")
.build()
)
);
env.execute();
}
}
Flink将数据写入到mysql
最新推荐文章于 2024-03-05 20:10:16 发布