Getting Json from a CSV


(Rajat Nigam) #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


(Eugeniy) #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


(Rajat Nigam) #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.


(Magnus B├Ąck) #4

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


(Mark Walkom) #5

Don't user rivers, they are deprecated!


(system) #6