Create Index Request Mapping is failing in elastic search

Question

I am trying to create the Join data type in the elastic search index, It is working from the kibana console / via rest but when I try to create the mapping for the index programmatically it fails with the below error,

java.util.concurrent.ExecutionException: RemoteTransportException[[3cfb4e163654][172.17.0.2:9300][indices:admin/create]]; nested: MapperParsingException[Failed to parse mapping [properties]: Root mapping definition has unsupported parameters:  [my_join_field : {type=join, relations={question=answer}}] [my_id : {type=keyword}]]; nested: MapperParsingException[Root mapping definition has unsupported parameters:  [my_join_field : {type=join, relations={question=answer}}] [my_id : {type=keyword}]];

Mapping :

{
    "properties": {
      "my_id": {
        "type": "keyword"
      },
      "my_join_field": { 
        "type": "join",
        "relations": {
          "question": "answer" 
        }
      }
    }
  }

Code :

public void createIndex(ReIndex indexObject) throws XXXDefinedException {
        String index = indexObject.getDestinationIndex();
        try {
            LOG.info("Initiating the index creation process for the " + index);
            CreateIndexRequest request = new CreateIndexRequest(index);
            if (!CommonUtils.isEmptyMap(indexObject.getMapping())) {
                LOG.info("Index Mapping Available : " + index);
                String indexMapping = new GsonBuilder().create().toJson(indexObject.getMapping());
                request.source(indexMapping, XContentType.JSON);
            }
            AcknowledgedResponse indexResponse = client.admin().indices().create(request).get();
            client.admin().indices().prepareRefresh().execute().actionGet();
            LOG.info("Index is created successfully : " + indexResponse);
        } catch (Exception e) {
            throw new XXXDefinedException (e);
        }
    }

where the inputObject.getMapping() has the following mapping :

  {"mappings":{"properties":{"my_id":{"type":"keyword"},"my_join_field":{"type":"join","relations":{"question":"answer"}}}}}

Can you add import statements also? looks like problem with the indexObject? — Gibbs
– Gibbs, Commented Jun 21, 2020 at 10:29

Kamal Kunjapur · Accepted Answer · 2020-06-22 09:52:01Z

1

Your inputObject.getMapping() should not be having the mapping part. Could you make the change in inputObject.getMapping() you have from:

{"mappings":{"properties":{"my_id":{"type":"keyword"},"my_join_field":{"type":"join","relations":{"question":"answer"}}}}}

to

{"properties":{"my_id":{"type":"keyword"},"my_join_field":{"type":"join","relations":{"question":"answer"}}}}

Let me know if that works out.

answered Jun 22, 2020 at 9:52

Kamal Kunjapur

8,9182 gold badges26 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Coder Over a year ago

Yes but elastic search internally stores as mapping -> mapping -> properties, check this link : so I use the request.source with {"mappings":{"mappings":{"properties":{"my_id":{"type":"keyword"},"my_join_field":{"type":"join","relations":{"question":"answer"}}}}}} and it worked

Coder Over a year ago

for reference check this link : techoverflow.net/2019/04/17/…

Kamal Kunjapur Over a year ago

Apologies, I made use of method request.mapping(jsonString,XContentType.JSON); and not the one you've used i.e. request.source(jsonString, XContenType.JSON);. I believe both should be correct enough and would eventually convert into correct JSON format required by elasticsearch. If you read the source code for CreateRequestIndex you would be able to see how both the methods are being used.

Kamal Kunjapur Over a year ago

Strange I've tried using source method with the mapping string you have and I still get the issue. Could you update the maven details, just want to check what ES version are you making use of. I've tried with 7.7 and both the times, only the JSON I've mentioned in the answer works, but not what you've mentioned in comment.

Coder Over a year ago

Could you help me on this please : stackoverflow.com/questions/62671455/elasticsearch-put-role-api

|

Collectives™ on Stack Overflow

Create Index Request Mapping is failing in elastic search

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related