input {
elasticsearch {
hosts => "ip:端口"
index => "es index"
query => '{"query":{"bool":{"must":[{"term":{"type":"user_order_goods"}}]}}}'
size => 500
scroll => "5m"
docinfo => true
}
}
output {
jdbc{
driver_jar_path => "/opt/logstash/logstash-jdbc/mysql-connector-java-5.1.46.jar"
driver_class => "com.mysql.jdbc.Driver"
connection_string => "jdbc:mysql://mysql地址?useUnicode=true&characterEncoding=UTF-8&useSSL=false&rewriteBatchedStatements=true&user=用户名&password=密码"
statement => ["INSERT INTO 表名(列名,列名,列名) values (?,?,?,from_unixtime(?/1000,'%Y-%m-%d %H:%i:%S'))","%{id}","%{userOrderId}"]
}
}
es-to-mysql
最新推荐文章于 2024-05-05 09:25:20 发布