I have a SQL database in my program and I use to view data ElasticSearch and for updates the SQL (I know that in the new version 6.3 i can do queries like SQL), but the problem that I have is that I have update of information using stored procedures but the document of elasticSearch not have these changes.
I don't think I understand the question.
You said that you have data in a SQL database and you update that data using stored procedures. But the updates going into your SQL database are not reflected in the Elasticsearch documents?
How do you look at the data from your SQL database with Elasticsearch?
First of all, sorry for my explanation that is not good. The mainly question is if I can update with SQL directly the register of elasticSearch. Now the update of ElasticSearch is on-demand but i would like can update the data of ElasticSearch everyday using the same SQL or another way to do it.
I think most people use logstash or some other app to pull new data from there source system and push into elastic, on a schedule E.g. every 5 minutes. This is best when elastic does not need to be updated in realtime.
The other option is for your app to push to both elastic and the source database.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.