Skip to content

Instantly share code, notes, and snippets.

@sergeycherepanov

sergeycherepanov/akeneo_elastic.md

Last active October 13, 2020 23:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sergeycherepanov/950f9100b6d85b56140fe3421e7b5ca3 to your computer and use it in GitHub Desktop.
Save sergeycherepanov/950f9100b6d85b56140fe3421e7b5ca3 to your computer and use it in GitHub Desktop.
Download ZIP
akeneo_elastic
Raw
akeneo_elastic.md

Run elastic

docker run -d --restart=always --name=akeneos_es -p 9200:9200 docker.elastic.co/elasticsearch/elasticsearch:6.5.4

Enable JDBC api and update index settings

curl -X POST 'http://localhost:9200/_xpack/license/start_trial?acknowledge=true'
curl -X PUT 'http://localhost:9200/_all/_settings?preserve_existing=true' -d '{"index.max_docvalue_fields_search" : "10000000"}' -H "Content-Type: application/json"
curl -X PUT 'http://localhost:9200/_all/_settings?preserve_existing=true' -d '{"index.max_result_window" : "10000000"}' -H "Content-Type: application/json"

Configure dbeaver

https://github.com/dbeaver/dbeaver/wiki/Database-drivers

Example driver config:

settings

x-pack-sql-jdbc-6.5.4.jar - https://yadi.sk/d/Ti4VLZPTEpOnKA

Tips

Allow delete (useful if ElasticSearch turned to readonly when disk is full)

curl -XPUT -H "Content-Type: application/json" http://localhost:9200/_all/_settings -d '{"index.blocks.read_only_allow_delete": null}'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment