# Elasticsearch insertion, deletion, updation
**URL:** https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956
**Category:** Elasticsearch
**Created:** [September 10, 2019, 6:30pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956 "2019-09-10T18:30:51Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Dv\_Thiyanesh](https://discuss.elastic.co/u/Dv_Thiyanesh)
#### Post date: [September 10, 2019, 6:30pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/1 "2019-09-10T18:30:51Z")
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
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [September 10, 2019, 6:42pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/2 "2019-09-10T18:42:40Z")
The Elasticsearch SQL support is limited to querying. In order to do CRUD you need to use the standard REST APIs.
---
### Author:  [@Dv\_Thiyanesh](https://discuss.elastic.co/u/Dv_Thiyanesh)
#### Post date: [September 10, 2019, 7:45pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/3 "2019-09-10T19:45:40Z")
we can use normal sql query as an input to perform curd in REST API? Any Reference link?
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [September 10, 2019, 7:47pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/4 "2019-09-10T19:47:02Z")
No, CRUD operations can not be done via SQL.
---
### Author:  [@Dv\_Thiyanesh](https://discuss.elastic.co/u/Dv_Thiyanesh)
#### Post date: [September 10, 2019, 7:48pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/5 "2019-09-10T19:48:32Z")
There is no way to convert or translate sql query to dsl query to perform operation
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [September 10, 2019, 7:56pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/6 "2019-09-10T19:56:53Z")
Not that I am aware of. If you require full SQL support you are probably limited to a RDBMS.
---
### Author:  [@Dv\_Thiyanesh](https://discuss.elastic.co/u/Dv_Thiyanesh)
#### Post date: [September 11, 2019, 12:46pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/7 "2019-09-11T12:46:53Z")
> [@Christian\_Dahlqvist](#):
>
> Not that I am aware of. If you require full SQL support you are probably limited to a RDBMS.
Cannot understand?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 9, 2019, 12:46pm UTC](https://discuss.elastic.co/t/elasticsearch-insertion-deletion-updation/198956/8 "2019-10-09T12:46:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.