# Elasticsearch Sql and json files

**URL:** <https://discuss.elastic.co/t/elasticsearch-sql-and-json-files/185823>\
**Category:** Elasticsearch\
**Created:** [June 14, 2019, 9:37am UTC](https://discuss.elastic.co/t/elasticsearch-sql-and-json-files/185823 "2019-06-14T09:37:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![aeljazouli](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@aeljazouli](https://discuss.elastic.co/u/aeljazouli)\
**Post date:** [June 14, 2019, 9:37am UTC](https://discuss.elastic.co/t/elasticsearch-sql-and-json-files/185823/1 "2019-06-14T09:37:42Z")

</div>

Hey there !

Can Elasticsearch sql be used to query json files ?

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [June 14, 2019, 4:17pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-and-json-files/185823/2 "2019-06-14T16:17:05Z")

</div>

Hi @aeljazouli,

ES SQL is for querying indices that exist in an Elasticsearch cluster. The query being used is translated to Elasticsearch query dsl that only looks at indices data. It doesn't query json files.

---

<div class="post-metadata">

**Author:** ![aeljazouli](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@aeljazouli](https://discuss.elastic.co/u/aeljazouli)\
**Post date:** [June 17, 2019, 9:39am UTC](https://discuss.elastic.co/t/elasticsearch-sql-and-json-files/185823/3 "2019-06-17T09:39:58Z")

</div>

Hi @Andrei_Stefan,

I already create an index that contains json document like this :

> {  
> "meta":{  
> "ID\_FICHIER":127743,  
> "DATE\_APPEL":"2019-06-06 10:22:42",  
> "SITE":"Casablanca"   
> },  
> "transcription":[  
> {  
> "confidence":0.985514,  
> "word":"energie"  
> },  
> {  
> "confidence":0.633511,  
> "word":"madame"  
> },  
> {  
> "confidence":0.533511,  
> "word":"pleine"  
> }  
> ]  
> }

I don't know if i can use the ES SQL too to querry that data or just the lucene query language ?

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [June 17, 2019, 5:05pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-and-json-files/185823/4 "2019-06-17T17:05:16Z")

</div>

@aeljazouli ES SQL is like standard SQL, with some [limitations](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-limitations.html). So, whatever you can do in standard SQL, it should work in ES SQL. Again, with some limitations.

Also, an additional set of features, specific only to ES SQL are these three functions: [https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-search.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-search.html)

And a very useful list of what functions and operators one can use in ES SQL, you can find here: [https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions.html)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 15, 2019, 5:05pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-and-json-files/185823/5 "2019-07-15T17:05:18Z")

</div>

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