logstash 使用 jdbc-output 写入数据到mysql 时,浮点数的小数点后几位会不精确。解决方案如下:
mysql 字段设置类型为double,不要设置精度
logstash插入的时候,把数据类型转换成string类型插入
filter {
if [type] == "appstart" {
json {
source => "message"
remove_field => ["message"]
}
date {
match => ["createTime", "yyyy-MM-dd HH:mm:ss"]
}
mutate {
convert => {
"lat" => "string"
"lng" => "string"
}
}
}
}
output {
stdout {
codec => rubydebug
}
jdbc {
driver_jar_path => "/home/elk/mysql-connector-java-5.1.45.jar"
driver_class => "com.mysql.jdbc.Driver"
connection_string => "*********