Elasticsearch insertion, deletion, updation

Dv_Thiyanesh · September 10, 2019, 6:30pm

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

Christian_Dahlqvist · September 10, 2019, 6:42pm

The Elasticsearch SQL support is limited to querying. In order to do CRUD you need to use the standard REST APIs.

Dv_Thiyanesh · September 10, 2019, 7:45pm

we can use normal sql query as an input to perform curd in REST API? Any Reference link?

Christian_Dahlqvist · September 10, 2019, 7:47pm

No, CRUD operations can not be done via SQL.

Dv_Thiyanesh · September 10, 2019, 7:48pm

There is no way to convert or translate sql query to dsl query to perform operation

Christian_Dahlqvist · September 10, 2019, 7:56pm

Not that I am aware of. If you require full SQL support you are probably limited to a RDBMS.

Dv_Thiyanesh · September 11, 2019, 12:46pm

Cannot understand?

system · October 9, 2019, 12:46pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.