Elasticsearch to CSV

es2csv.md

Elasticsearch to CSV

Roadmap:

1. Dump index from es using elasticdump
2. Convert to csv using json2csv
   (optional)
   
3. Extract one column using csvtool
4. Visualize the data using VisData

Code

elasticdump \
  --input=http://localhost:9100/my_index \
  --output=dump.json \
  --type=data
  
json2csv -n --flatten-objects -i dump.json -o dump.csv

# Optional
csvtool col 5,9 dump.csv > 59.csv # extract 5th and 9th columns
vd 59.csv