Have a look at https://github.com/jprante/elasticsearch-river-jdbc/wiki/Strategies#simple-strategy the poll time value can be adjusted to the interval how often data should be fetched.
HTH -- David ;-) Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 18 déc. 2013 à 07:35, Mohit Kumar Yadav <[email protected]> a écrit : 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 [email protected]. 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. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/67D07329-5944-49DE-9C8A-B3624F42DE12%40pilato.fr. For more options, visit https://groups.google.com/groups/opt_out.
