Hi folks, I am trying create river for mysql to elasticsearch. I have successfully created that but data is not mapping dynamically. when I restart the elasticsearch then the changes in data visible. for - example :- step 1 : In mysql database table "tbl_test" has 3 row and 3 column. step 2 : when i start the Elastic search I got 3 document. step 3 : now i add 2 rows in tbl_test (total 5 rows and 3column.) step 4 : elasticsearch it is showing only 3 documents. but when I restart elasticsearch it is showing all documents that is 5 documents.
Below is my the query : { "type": "jdbc", "jdbc": { "driver": "com.mysql.jdbc.Driver", "url": "jdbc:mysql://localhost:3306/test", "user": "root", "password": "admin", "sql": "select * from tbl_test", "index": "mySql_index", "type": "mySql_indext", "bulk_size": "100", "bulk_timeout": "10ms", "strategy": "simple" } } *Question:* how can I achieve this dynamically. I am using Elasticsearch version 0.90.7 and river-jdbc ( version - 2.3.1 ) thanks in advance...!!! Regrads Mohit Kumar Yadav (MCA/BBA) -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAK6eDKfnHYyeWh_JzW7WQ2iQfBvymkQJpT_FKatT2ytMsrw%3Dcw%40mail.gmail.com. For more options, visit https://groups.google.com/groups/opt_out.