# ElasticSearch and JSON SparkSQL

**URL:** <https://discuss.elastic.co/t/elasticsearch-and-json-sparksql/38787>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [January 9, 2016, 12:29pm UTC](https://discuss.elastic.co/t/elasticsearch-and-json-sparksql/38787 "2016-01-09T12:29:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ebuildy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ebuildy/32/6070_2.png) [@ebuildy](https://discuss.elastic.co/u/ebuildy)\
**Post date:** [January 9, 2016, 12:29pm UTC](https://discuss.elastic.co/t/elasticsearch-and-json-sparksql/38787/1 "2016-01-09T12:29:00Z")

</div>

Hello,

Just curious, is this plugin using the JSON support of SparkSQL (I mean [http://spark.apache.org/docs/latest/sql-programming-guide.html#json-datasets](http://spark.apache.org/docs/latest/sql-programming-guide.html#json-datasets)).

Currently I have always a trouble with ES schema, and as a workaround, I export my ES data as a big JSON file and load it using `org.apache.spark.sql.json`, here no problem about nested, arrays etc...

Thanks you,

---

<div class="post-metadata">

**Author:** ![costin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/costin/32/44950_2.png) [@costin](https://discuss.elastic.co/u/costin)\
**Post date:** [January 9, 2016, 1:42pm UTC](https://discuss.elastic.co/t/elasticsearch-and-json-sparksql/38787/2 "2016-01-09T13:42:50Z")

</div>

No, it does not.  
Sorry to hear about your issues, can you try ES-Hadoop 2.2-rc1 and report back if addresses your problem. If so, can you please post a sample of your JSON.

Thanks,

---

<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 6, 2017, 1:26pm UTC](https://discuss.elastic.co/t/elasticsearch-and-json-sparksql/38787/3 "2017-07-06T13:26:38Z")

</div>