使用Logstash向Mysql的json类型字段插入时报错。
[ERROR] 2022-09-26 16:55:50.316 [[main]>worker3] jdbc - JDBC - Exception.
Not retrying {:exception=>org.postgresql.util.PSQLException: ERROR: column "test_column" is of type json but expression is of type character varying
解决办法: 将sql语句中json字段对应的 ? 改为 ?::jsonb
例如:
INSERT INTO xxx (id, json_column) VALUES(?, ?)
改为如下
INSERT INTO xxx (id, json_column) VALUES(?, ?::jsonb)
参考自:https://stackoverflow.com/questions/38967373/logstash-output-plugin-for-jdbc-mysql
标签:...,column,character,but,json,报错,ERROR,type From: https://www.cnblogs.com/feng-gamer/p/16731803.html