# \[routing\] is missing for join field \[relation\]

**URL:** <https://discuss.elastic.co/t/routing-is-missing-for-join-field-relation/162502>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [December 31, 2018, 10:29am UTC](https://discuss.elastic.co/t/routing-is-missing-for-join-field-relation/162502 "2018-12-31T10:29:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![IlyaG](https://avatars.discourse-cdn.com/v4/letter/i/b2d939/32.png) [@IlyaG](https://discuss.elastic.co/u/IlyaG)\
**Post date:** [December 31, 2018, 10:29am UTC](https://discuss.elastic.co/t/routing-is-missing-for-join-field-relation/162502/1 "2018-12-31T10:29:39Z")

</div>

Process:  
I receive data from spark as Dataset. Then it is mapped to MyObject (according to the ES mapping) using map() function. Result is converted to RDD and passed to JavaEsSpark.saveToEs().

```
public class MyObject implements Serializable {

    //some fields

    private MyRelation relation;
}

public class MyRelation implements Serializable {
    private String parent;
    private String name = "child";

    public MyRelation(String parent) {
        this.parent = parent;
    }
}

```

This is how data is inserted:

```
    JavaEsSpark.saveToEs(
                rdd,
                "myIndex/myType,
                ImmutableMap.of(
                        ConfigurationOptions.ES_MAPPING_JOIN, "relation")));

```

Relation from the mapping:

```
        "relation": {
            "type": "join",
            "eager_global_ordinals": true,
            "relations": {
              "parent": "child"
            }
          },

```

And, finally, the error:

```
    Previous handler messages:
        Non retryable code [400] encountered.
org.elasticsearch.hadoop.rest.EsHadoopRemoteException: mapper_parsing_exception: failed to parse
        at org.elasticsearch.hadoop.rest.ErrorExtractor.extractErrorWithCause(ErrorExtractor.java:30)
        at org.elasticsearch.hadoop.rest.ErrorExtractor.extractError(ErrorExtractor.java:60)
        at org.elasticsearch.hadoop.rest.bulk.BulkProcessor.tryFlush(BulkProcessor.java:245)
        at org.elasticsearch.hadoop.rest.bulk.BulkProcessor.flush(BulkProcessor.java:499)
        at org.elasticsearch.hadoop.rest.bulk.BulkProcessor.close(BulkProcessor.java:541)
        at org.elasticsearch.hadoop.rest.RestRepository.close(RestRepository.java:219)
        at org.elasticsearch.hadoop.rest.RestService$PartitionWriter.close(RestService.java:121)
        at org.elasticsearch.spark.rdd.EsRDDWriter$$anonfun$write$1.apply(EsRDDWriter.scala:60)
        at org.elasticsearch.spark.rdd.EsRDDWriter$$anonfun$write$1.apply(EsRDDWriter.scala:60)
        at org.apache.spark.TaskContext$$anon$1.onTaskCompletion(TaskContext.scala:128)
        at org.apache.spark.TaskContextImpl$$anonfun$markTaskCompleted$1.apply(TaskContextImpl.scala:118)
        at org.apache.spark.TaskContextImpl$$anonfun$markTaskCompleted$1.apply(TaskContextImpl.scala:118)
        at org.apache.spark.TaskContextImpl$$anonfun$invokeListeners$1.apply(TaskContextImpl.scala:131)
        at org.apache.spark.TaskContextImpl$$anonfun$invokeListeners$1.apply(TaskContextImpl.scala:129)
        at scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)
        at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:48)
        at org.apache.spark.TaskContextImpl.invokeListeners(TaskContextImpl.scala:129)
        at org.apache.spark.TaskContextImpl.markTaskCompleted(TaskContextImpl.scala:117)
        at org.apache.spark.scheduler.Task.run(Task.scala:125)
        at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:345)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.elasticsearch.hadoop.rest.EsHadoopRemoteException: illegal_argument_exception: [routing] is missing for join field [relation]
        at org.elasticsearch.hadoop.rest.ErrorExtractor.extractErrorWithCause(ErrorExtractor.java:30)
        at org.elasticsearch.hadoop.rest.ErrorExtractor.extractErrorWithCause(ErrorExtractor.java:39)

```

Before inserting children, i insert a parent, and it is written to es successfully.  
Adding a ConfigurationOptions.ES\_MAPPING\_ROUTING together with the existing document didn't help.  
Same documents without relation are written successfully

Any help would very appreciated!

---

<div class="post-metadata">

**Author:** ![IlyaG](https://avatars.discourse-cdn.com/v4/letter/i/b2d939/32.png) [@IlyaG](https://discuss.elastic.co/u/IlyaG)\
**Post date:** [December 31, 2018, 12:53pm UTC](https://discuss.elastic.co/t/routing-is-missing-for-join-field-relation/162502/2 "2018-12-31T12:53:20Z")

</div>

Problem solved. I was missing one closing bracket.

---

<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:** [January 28, 2019, 12:53pm UTC](https://discuss.elastic.co/t/routing-is-missing-for-join-field-relation/162502/3 "2019-01-28T12:53:37Z")

</div>

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