# sqlContext.read.format("es").load() set es.nodes

**URL:** <https://discuss.elastic.co/t/sqlcontext-read-format-es-load-set-es-nodes/80072>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [March 27, 2017, 6:32am UTC](https://discuss.elastic.co/t/sqlcontext-read-format-es-load-set-es-nodes/80072 "2017-03-27T06:32:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![whybangbang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/whybangbang/32/7116_2.png) [@whybangbang](https://discuss.elastic.co/u/whybangbang)\
**Post date:** [March 27, 2017, 6:32am UTC](https://discuss.elastic.co/t/sqlcontext-read-format-es-load-set-es-nodes/80072/1 "2017-03-27T06:32:46Z")

</div>

my elasticsearch in other nodes, but sqlContext cat't find this node  
org.elasticsearch.hadoop.rest.EsHadoopNoNodesLeftException: Connection error (check network and/or proxy settings)- all nodes failed; tried [[localhost:9200]]

conf = {"es.resource" : "xxx/xxx", "es.nodes": "10.10.1.111:9200"}  
sc = SparkContext("local[\*]", "es\_spark",conf=conf)  
sqlContext = SQLContext(sc)  
df = sqlContext.read.format("org.elasticsearch.spark.sql").load("xxx/xxx")

---

<div class="post-metadata">

**Author:** ![james.baiera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james.baiera/32/10209_2.png) [@james.baiera](https://discuss.elastic.co/u/james.baiera)\
**Post date:** [March 27, 2017, 4:12pm UTC](https://discuss.elastic.co/t/sqlcontext-read-format-es-load-set-es-nodes/80072/2 "2017-03-27T16:12:33Z")

</div>

@whybangbang Could you include trace level logging for your job driver? That should help shed some light on the issue you're experiencing.

---

<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:** [April 24, 2017, 4:12pm UTC](https://discuss.elastic.co/t/sqlcontext-read-format-es-load-set-es-nodes/80072/3 "2017-04-24T16:12:52Z")

</div>

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