I am using java client API and established connection with elastic search and my requirement is i need to take a sql query from the user and with that sql query i need to perform CRUD operation. i have used translate method it only to fetch already available data i need to perform other operation too. what can i do for that? Any other way
The Elasticsearch SQL support is limited to querying. In order to do CRUD you need to use the standard REST APIs.
we can use normal sql query as an input to perform curd in REST API? Any Reference link?
No, CRUD operations can not be done via SQL.
There is no way to convert or translate sql query to dsl query to perform operation
Not that I am aware of. If you require full SQL support you are probably limited to a RDBMS.