Rebuild strategy

Rebuild strategy for the elasticsearch-jdbc-river (https://github.com/jprante/elasticsearch-jdbc) The master branch supports elasticsearch-jdbc version 1.7.0.1 and higher. The 1.4 branch supports elasticsearch-jdbc versions till 1.5.2.0.

Usage

This strategy can be used to update Elasticsearch indices periodically. It simply rebuilds the index and it can be done at a specified interval.

The stategy uses an alias to map to the active index with documents. The alias will be switched to the new builded index after the rebuild is completed (atomic operation). The old index will be deleted after the switch.

Configuration

First add the JAR file of this project to the classpath of the elasticsearch-jdbc-river.

then you can use a feeder config like this:

{
    "elasticsearch" : {
        "cluster" : "elasticsearch",
        "host" : "localhost",
        "port" : 9300
    },
    "strategy" : "rebuild",
    "interval" : 60000,
    "jdbc" : {
        "url": "jdbc:oracle:thin:@oracldbserver:1521:mydb",
        "user": "superman",
        "password": "secret",
        "sql": [  "select 'car' as \"_type\", c.* from cars c" ,
                  "select 'bike' as \"_type\", b.* from bikes b" ],
        "treat_binary_as_string": true,
        "alias": "vehicles",
        "index_prefix": "vehicles_",
        "template": "vehicles_index.json",
        "keep_last_indices": 3
    }
}

Important settings (rebuild strategy specific. See for the other parameters: https://github.com/jprante/elasticsearch-jdbc#parameters-inside-of-the-jdbc-block):

alias - [required] The name of the alias that will be created.

index_prefix - [optional] The prefix of the generated index. A timestamp will be added after the prefix to make it unique. The default value is "{alias}_"

template - [optional] Path to a JSON file containing the template to create the index (settings, mappings).

keep_last_indices - [optional] Keep a number of old indices (last indices). The default value is: 0

Example of a template file (vehicles_index.json)

{
    "settings": {
        "index" : {
            "number_of_shards" : 1,
            "refresh_interval" : 1,
            "number_of_replicas" : 0
        },
        "analysis": {
            "analyzer": {
                // lines removed!
            }
        }
    },
    "mappings": {
        "car": {
            "_source": {
                "enabled": true
            },
            "_all": {
                "enabled": false
            },
            "properties": {
                // lines removed!
            }
        },
        "bike": {
            "_source": {
                "enabled": true
            },
            "_all": {
                "enabled": false
            },
            "properties": {
                // lines removed!
            }
        }
    }
}