# Error with pyspark connect es

**URL:** <https://discuss.elastic.co/t/error-with-pyspark-connect-es/246560>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [August 27, 2020, 6:55am UTC](https://discuss.elastic.co/t/error-with-pyspark-connect-es/246560 "2020-08-27T06:55:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sophieag](https://avatars.discourse-cdn.com/v4/letter/s/3bc359/32.png) [@sophieag](https://discuss.elastic.co/u/sophieag)\
**Post date:** [August 27, 2020, 6:55am UTC](https://discuss.elastic.co/t/error-with-pyspark-connect-es/246560/1 "2020-08-27T06:55:08Z")

</div>

**I use the below code to write spark dataframe data to es.**

```auto
df.write.format("org.elasticsearch.spark.sql").option("es.nodes","172.17.37.88,172.17.37.89,172.17.37.90").option("es.resource", "pyspark_es/data").option("es.mapping.id", "id").mode('overwrite').save()

```

**However, I got an error.**

```auto
py4j.protocol.Py4JJavaError: An error occurred while calling o108.save.
: org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: Cannot detect ES version - typically this happens if the network/Elasticsearch cluster is not accessible or when targeting a WAN/Cloud instance without the proper setting 'es.nodes.wan.only'
        at org.elasticsearch.hadoop.rest.InitializationUtils.discoverClusterInfo(InitializationUtils.java:344)
        at org.elasticsearch.spark.sql.ElasticsearchRelation.cfg$lzycompute(DefaultSource.scala:225)
        at org.elasticsearch.spark.sql.ElasticsearchRelation.cfg(DefaultSource.scala:223)
        at org.elasticsearch.spark.sql.ElasticsearchRelation.insert(DefaultSource.scala:603)
        at org.elasticsearch.spark.sql.DefaultSource.createRelation(DefaultSource.scala:108)
        at org.apache.spark.sql.execution.datasources.SaveIntoDataSourceCommand.run(SaveIntoDataSourceCommand.scala:46)
        at org.apache.spark.sql.execution.command.ExecutedCommandExec.sideEffectResult$lzycompute(commands.scala:70)
        at org.apache.spark.sql.execution.command.ExecutedCommandExec.sideEffectResult(commands.scala:68)
        at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:86)
        at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
        at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
        at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
        at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
        at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
        at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
        at org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:80)
        at org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:80)
        at org.apache.spark.sql.DataFrameWriter$$anonfun$runCommand$1.apply(DataFrameWriter.scala:654)
        at org.apache.spark.sql.DataFrameWriter$$anonfun$runCommand$1.apply(DataFrameWriter.scala:654)
        at org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:77)
at org.apache.spark.sql.DataFrameWriter.runCommand(DataFrameWriter.scala:654)
        at org.apache.spark.sql.DataFrameWriter.saveToV1Source(DataFrameWriter.scala:273)
        at org.apache.spark.sql.DataFrameWriter.save(DataFrameWriter.scala:267)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)
        at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
        at py4j.Gateway.invoke(Gateway.java:282)
        at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
        at py4j.commands.CallCommand.execute(CallCommand.java:79)
        at py4j.GatewayConnection.run(GatewayConnection.java:214)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.elasticsearch.hadoop.rest.EsHadoopInvalidRequest: org.elasticsearch.hadoop.rest.EsHadoopRemoteException: security_exception: missing authentication token for REST request [/]
null
        at org.elasticsearch.hadoop.rest.RestClient.checkResponse(RestClient.java:448)
        at org.elasticsearch.hadoop.rest.RestClient.execute(RestClient.java:405)
        at org.elasticsearch.hadoop.rest.RestClient.execute(RestClient.java:367)
        at org.elasticsearch.hadoop.rest.RestClient.execute(RestClient.java:371)
        at org.elasticsearch.hadoop.rest.RestClient.get(RestClient.java:166)
        at org.elasticsearch.hadoop.rest.RestClient.mainInfo(RestClient.java:692)
        at org.elasticsearch.hadoop.rest.InitializationUtils.discoverClusterInfo(InitializationUtils.java:334)
        ... 33 more
End of LogType:stdout

```

My spark version in cluster is 2.3.0 and es version is 6.7.2. I submit the spark program with:  
spark-submit --jars elasticsearch-hadoop-6.7.2.jar \*\*\* in my client

---

<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:** [September 24, 2020, 6:55am UTC](https://discuss.elastic.co/t/error-with-pyspark-connect-es/246560/2 "2020-09-24T06:55:15Z")

</div>

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