Getting Json from a CSV

(Rajat Nigam) #1


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.


(Eugeniy) #2

Hi, see for example or 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