# Elastic SQL
**URL:** https://discuss.elastic.co/t/elastic-sql/327525
**Category:** Elasticsearch
**Created:** [March 13, 2023, 6:31am UTC](https://discuss.elastic.co/t/elastic-sql/327525 "2023-03-13T06:31:49Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@\_baba](https://discuss.elastic.co/u/_baba)
#### Post date: [March 13, 2023, 6:31am UTC](https://discuss.elastic.co/t/elastic-sql/327525/1 "2023-03-13T06:31:49Z")
Hi, I'm not able to execute sql queries from kibana on AWS managed Elasticsearch, however I can execute it via REST call. Can someone help me identify what's the root cause of this?
Query:
POST /\_sql
{
"query": "SELECT \* FROM Table\_Name WHERE ((filed1= 'Value1') AND (field2 = 'value2'))",
"fetch\_size": 5
}
Error output: {"Message":"Your request: '/\_sql' is not allowed."}
ES version: v 7.10.2
---
### Author:  [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)
#### Post date: [March 13, 2023, 10:48am UTC](https://discuss.elastic.co/t/elastic-sql/327525/2 "2023-03-13T10:48:20Z")
Hi @_baba
Try this:
```auto
POST _opendistro/_sql?
{
"query": "SELECT * FROM Table_Name WHERE ((filed1= 'Value1') AND (field2 = 'value2'))",
"fetch_size": 5
}
```
This [**doc**](https://docs.aws.amazon.com/opensearch-service/latest/developerguide/sql-support.html) have more details.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 13, 2023, 10:48am UTC](https://discuss.elastic.co/t/elastic-sql/327525/3 "2023-03-13T10:48:20Z")
OpenSearch/OpenDistro are AWS run products and differ from the original Elasticsearch and Kibana products that Elastic builds and maintains. You may need to contact them directly for further assistance.
(This is an automated response from your friendly Elastic bot. Please report this post if you have any suggestions or concerns :elasticheart: )
---
### Author:  [@\_baba](https://discuss.elastic.co/u/_baba)
#### Post date: [March 17, 2023, 6:25am UTC](https://discuss.elastic.co/t/elastic-sql/327525/4 "2023-03-17T06:25:17Z")
Thanks for your response, it works from kibana.
Can you please help me with the builder that we can use from the REST API (java).
I tried both QueryStringQueryBuilder, and SimpleQueryStringBuilder but these convert the query to query\_string below which I'm not looking for.
{
"query": {
"simple\_query\_string": {
```
"query" : "SELECT * FROM Table_Name WHERE ((filed1= 'Value1') AND (field2 = 'value2'))",
"fields" : []
}
```
}
}
I have also gone through this [doc](https://www.elastic.co/guide/en/elasticsearch/client/java-rest/current/java-rest-high-query-builders.html) to find a suitable builder with no luck.
Any lead would be appreciated.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [March 17, 2023, 7:11am UTC](https://discuss.elastic.co/t/elastic-sql/327525/5 "2023-03-17T07:11:14Z")
You are using a third party plugin that is not core Elasticsearch. None of the official clients will therefore have any built in support for this.
---
### Author:  [@\_baba](https://discuss.elastic.co/u/_baba)
#### Post date: [March 17, 2023, 7:44am UTC](https://discuss.elastic.co/t/elastic-sql/327525/7 "2023-03-17T07:44:04Z")
Thanks for details. Can you suggest any querybuilder for Elasticsearch SQL core library, we can migrate from 3rd party plugin to core ES.
POST \_sql/
{
"query": "SELECT \* FROM Table\_Name WHERE ((filed1= 'Value1') AND (field2 = 'value2'))",
",
"fetch\_size": 5
}
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 17, 2023, 8:41am UTC](https://discuss.elastic.co/t/elastic-sql/327525/9 "2023-03-17T08:41:00Z")
You would have to move from OpenSearch to Elasticsearch actually. Those are 2 different products.
You can easily run Elasticsearch on AWS either from the marketplace or better from [cloud.elastic.co](http://cloud.elastic.co). Then you will have access to the full Elasticsearch experience.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 14, 2023, 8:41am UTC](https://discuss.elastic.co/t/elastic-sql/327525/10 "2023-04-14T08:41:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.