Elastic Search- Distinct elements from multiple nested fields

Question

I have created mapping using elasticsearch. Here is the mapping properties

"properties": {
         "userPermissions": {
            "type": "nested",
            "properties": {
                "prm": {
                    "type": "string"
                },
                "id": {
                    "type": "string"
                }
            }
           },
         "pSPermissions": {
            "type": "nested",
            "properties": {
                "prm": {
                "type": "string"
                },
                "id": {
                "type": "string"
                }
            }
         }
      }

I want to retrieve overall distinct items from these fields: userPermissions.id, pSPermissions.id.

I can achieve distinct values of multiple fields under a single path. We need to use a script to retrieve terms from multiple fields.

GET /permissions/perm/_search?pretty=true&search_type=count

    {
      "aggs": {
        "Parents": {
          "nested": {
            "path": "userPermissions"
          },
          "aggs": {
            "permCount": {
              "terms": {
                "script": "[doc['userPermissions.id'].value,doc['userPermissions.prm'].value]",
                "size": 5000
              }
            }
          }
        }
      }
    }

But I have no idea how to achieve across different paths userPermissions and pSPermissions. Is it achievable?

Val · Accepted Answer · 2015-10-17 04:49:51Z

1

You can achieve it using the following script:

"script": "doc['userPermissions.id'].values + doc['userPermissions.prm'].values",

What it does is retrieve all the userPermissions.id values and all the userPermissions.prm values and then concatenate them into a single array using groovy's + operator.

UPDATE

Following up on your comment, you can achieve what you want with this script in a similar way as you're already doing for fields under the same path:

"script": "doc['userPermissions.id'].values + doc['pSPermissions.id'].values",

edited Oct 17, 2015 at 4:49

answered Oct 16, 2015 at 12:55

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

Viola Pinto Over a year ago

I have achieved already what you are suggesting. The problem what I have is, I want concatenated values of userPermissions.id and pSPermissions.id into a single array.

Collectives™ on Stack Overflow

Elastic Search- Distinct elements from multiple nested fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related