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+unsubscribe@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.