Hi, I'm using jdbc mysql river plugin https://github.com/jprante/elasticsearch-river-jdbc for creating ES index. I have been able to index my documents successfully but I'm facing issues in updating/deleting indexed documents. My jdbc river is used with a sql query that uses multiple joins on tables and return results. These results are then indexed in ES. My problem is if I update some tables they will affect the results of that join query which should be reflected in ES index but ES index is not updating/deleting sql results from that join query. I found few threads where people are facing similar issue.
http://stackoverflow.com/questions/21260086/elasticsearch-river-jdbc-mysql-not-deleting-records I'm using ES 1.1.0 with jdbc river version 1.1.0.2. There is one more thread from author itself where he states that deletions are no longer supported. He tells two methods of tackling the issue. One is re indexing itself and second is using some sql queries to update/delete indexed documents. https://github.com/jprante/elasticsearch-river-jdbc/issues/202 Can anyone please tell me how can I tackle the issue. How can I update/delete already indexed documents. Can anyone please elaborate on the second method of updating/deleting indexed documents. Thanks -- 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/f1179d7d-4232-4444-b0ee-e7ac383a4bfc%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
