Scripted field to count array length

Question

I have the following document:

{
  "likes": {
    "data": [
      {
        "name": "a"
      },
      {
        "name": "b"
      },
      {
        "name": "c"
      }
    ]
  }
}

I'm trying to run an update_by_query that will add a field called 'like_count' with the number of array items inside likes.data

It's important to know that not all of my documents have the likes.data object.

I've tried this:

POST /facebook/post/_update_by_query
{
  "script": {
  "inline": "if (ctx._source.likes != '') { ctx._source.like_count = ctx._source.likes.data.length }",
    "lang": "painless"
  }
}

But getting this error message:

{
    "type": "script_exception",
    "reason": "runtime error",
    "script_stack": [
      "ctx._source.like_count = ctx._source.likes.data.length }",
      "                                               ^---- HERE"
    ],
    "script": "if (ctx._source.likes != '') { ctx._source.like_count = ctx._source.likes.data.length }",
    "lang": "painless"
  }

Yes, getting the same error message. If I update a single document everything works (with .length), but when I try to run an update_by_query I get this error message. I suspect it is because some documents do not have the likes object, but I have the if statement to handle that. — Or Weinberger
– Or Weinberger, Commented Jun 14, 2017 at 15:02
I think your condition ctx._source.likes != '' should read ctx._source.likes != null — Val
– Val, Commented Jun 14, 2017 at 22:56
Have you tried using something like ctx._source['likes.data.name'].values.length? — skipper
– skipper, Commented Jun 21, 2017 at 11:11

kennywu0616 · Accepted Answer · 2017-06-22 12:24:25Z

5

Try ctx._source['likes.data.name'].length

According to https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html, the object array in ES is flattened to

{
   "likes.data.name" :["a", "b", "c"] 
}

The object array datatype we thought is Nest datatype.

answered Jun 22, 2017 at 12:24

kennywu0616

591 bronze badge

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

Comments

Akshay Maniyar · Accepted Answer · 2019-01-04 07:00:15Z

1

Try this

ctx._source['likes']['data'].size()

answered Jan 4, 2019 at 7:00

Akshay Maniyar

494 bronze badges

Collectives™ on Stack Overflow

Scripted field to count array length

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related