grails (11) vaadin (11) meteor (6) java (4) elasticsearch (3) apple (2) centos (1) cloudbees (1) google analytics (1) gradle (1) heroku (1) javafx (1) javascript (1) jdbc (1) jug (1) logback (1) logging (1) mac os (1) management (1) mongodb (1) mongolab (1) mysql (1) twitter (1) ubuntu (1)

Monday, October 28, 2013

How to configure JDBC river for ElasticSearch

Updated for new version of ElasticSearch 1.0.0.

JDBC river makes possible to load data from e.g. MySql database to ElasticSearch and provide data much faster. 

Before we start, have a look at the set of jdbc-river parameters. Then you need to pick-up a strategy how to poll data from JDBC. 

TextLab for Mac
Ultimate application to validate, clean and format JSON, XML, SQL, HTML.


  1. Hi, shouldn't index_name be index_type in your example?

  2. It was actually working as it is. ES river has changed this? I couldn't find it in documentation.

  3. don't know, i got it working but used the type index_type, maybe it works because there is no other type in the index. Anyways, thanks for this post.

  4. You are right, index_type must be used... I fixed it.

  5. do u need to create an empty index first? mine is not honoring my mappings. what do you mean by index_type? i don't see that in your example.