Logstash-inputjdbc postgresql json type import to ES problem


(maleibo) #1

hello !
i have a postgresql database ,some columns of type is json.
i used input-jdbc plugin to import these datas,but there is a problem,for example:
my json column data:
{"type":"Point","coordinates":[106.1223,29.3467]}
input-jdbc import data:
{"type":"json","value":"{"type":"Point","coordinates":[106.1223,29.3467]}"}

ES can not parse this format,how can i do it?
my english is poor,do you know my means?


(Magnus B├Ąck) #2

Use a json filter on your value field to parse the JSON string.


(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.