@Suhas_K It worked out as expected. One more thing : I am bringing all the jobs and their status from Oracle and I want data to update real time. So that the status would change in front end also. So first time the data would be indexed by select * in logstash.conf. How should my query be written so that the older values are deleted and the new values added?
I hope you understand. The new values of status should override the older ones so I think I would select * again so as to include new jobs and updated status of previously indexed jobs but how to delete the older values or is there any other way.
This would be the order :
- Select * and index jobs and their status into ES.
- Delete everything that was indexed and select * again with new values which will be indexed.