Getting Json from a CSV

Elastic Stack Logstash
1

Hi,

I have a usecase where I have CSV files with a few columns with JSON values. How can I take the get the JSON column and store it in elasticsearch?

Thanks a lot! Much appreciate everyone's help.

Regards,
Rajat

2

Hi, see github.com/AgileWorksOrg/elasticsearch-river-csv for example or www.elastic.co/guide/en/logstash/current/plugins-filters-csv.html will be interesting for you

3

Thank you for the response. I did explore the csv filter earlier but what is not clear to me is if the column value will automatically be recognized as a JSON and then further parsed before being saved to EMR.

4

Use a csv filter to split up the CSV strings, then use the json filter on the field(s) containing JSON data.

5

Don't user rivers, they are deprecated!