首页 > 其他分享 >解决报错:ERROR: column is of type json but expression is of type character varying...

解决报错:ERROR: column is of type json but expression is of type character varying...

时间:2022-09-26 17:57:07浏览次数:85  
标签:... column character but json 报错 ERROR type

使用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

相关文章