Logstash jdbc string column value in sql. how to split individual field and value

saravana_hariharan · January 6, 2020, 1:04pm

sql column value concatenated in {"ID":"P0001","Name":"sam","Createdby:124","Createdtime":"157312334321"}
In the above line is my sample data in one clolumn value of sql table

how to split this column to individual field in logstash and i
like individualy ID ,Name,Createdby,Createdtime in discover dashboard in kibana

Help me,
Saravanan R

Badger · January 6, 2020, 2:58pm

Use a json filter.

saravana_hariharan · January 7, 2020, 6:48am

Iam use it bro but it cant work in oracledata to logstash
kv {
source => "value"
field_split => ":"

Badger · January 7, 2020, 2:53pm

A kv filter is not a json filter.

saravana_hariharan · January 8, 2020, 10:52am

im beginner so can you please give that code for filter

system · February 5, 2020, 10:56am

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