Thank you Kevin for your reply, But i was searching for the command which will directly update the data without deleting and creating the indexes.
Is there any command like curl -X UPDATE in elasticsearch ? which will not add already existing data in elastic. On Monday, February 10, 2014 3:38:28 PM UTC+5:30, Kevin Wang wrote: > > You can use JDBC river plugin to fetch from database directly. > > https://github.com/jprante/elasticsearch-river-jdbc > > > > On Monday, February 10, 2014 8:40:31 PM UTC+11, Vallabh Bothre wrote: >> >> Dear All, >> >> I am using elasticsearch in some of the my API. >> I have created the index and document and have added data in >> elasticsearch server from Mysql database. >> >> I am following 3 steps that is, >> 1. Delete the index using >> curl -X DELETE 'http://localhost:9200/adminvenue/?pretty=true' >> >> 2. Create the index using >> curl -X PUT 'http://localhost:9200/adminvenue/?pretty=true' -d ' >> {....... >> >> 3. Create the mapping using >> curl -X PUT ' >> http://localhost:9200/adminvenue/jos_content/_mapping?pretty=true' -d ' >> {...... >> >> >> I have set the cron which runs every half an hour. >> Cron consist of 2 files named .sh file which is for >> creating/deleting/mapping indexes and .php which is use for adding data >> from mysql to elasticsearch. >> >> My mysql data is continuously updating that is some data get removed some >> modified and some added because of this i have run cron for 1/2 hour. >> >> My concerns is that i have to first delete the indexes and then create >> the indexes in every 1/2 hour. >> Is there any way to update the indexes that is i just wanted to update >> the data in elasticsearch which is added, deleted and modified in mysql ? >> >> Any suggestion is very much appreciated. >> >> Thanks, >> Vallabh >> >> -- 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/1f8c781f-2a67-48ee-8f77-bd38a3d8a40e%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
