elkcsv

Elastic Csv

Very basic use case to load csv datas into elasticsearch in order to perform an aggregate request.

Requirements

• elasticsearch
• logstash
• php

Setup

Follow this tuto

Fixtures

Csv

Here you can find csv compressed dataset files.
Uncompress before use.
Remind that logstash should have full access to the import directory.

Logstash

Here you can find a logstash template importer.
Change pathes and filter columns according your requirements.
Copy to /etc/logstash/conf.d

# Ensure elastic instance is up
sudo systemctl status elasticsearch.service
# If not start it
sudo systemctl start elasticsearch.service
# Start logstash
sudo systemctl start logstash.service

Req

Here you can find some template requests.

Res

Here you can find some sample response.

Usage

composer install
composer start

Tools

• Multi Elasticsearch head chrome extension

Doc

Elasticsearch

• Update number of shards to improve performances.
• Size your shards.
• Dynamic templates and mapping.