I am trying to feed data into Elastic Search using jdbc river but this river is not getting all the data. I have 450000 records in MySQL table but in ES i get only about 230000 records.
Here is my ES river setting:
curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "test",
"password" : "test",
"sql" : "select * from test" },
"index":{
"index" : "test",
"bulk_size":600,
"max_bulk_requests":10,
"bulk_timeout":"5s",
"autocommit":"true"
}
}'
I have looked in Elastic Search documentation but i could not find the solution. I am using river-jdbc-1.1.0.2 version.