How do I get the count/size of an array in elasticsearch

Question

I want to do a statistical facet on one of my arrays. I hope something like

"script" : "doc['myField'].doubleValue

or

"script" : "doc['myField'].count

would work. I havent found any array count method in mvel and I don't even know if accessing the array field in a script actually gives me the array.

Have a look here: stackoverflow.com/questions/12733351/…

javanna
– javanna

2013-03-15 17:42:14 +00:00
Commented Mar 15, 2013 at 17:42 — javanna
– javanna, Commented Mar 15, 2013 at 17:42

Alden · Accepted Answer · 2013-03-15 17:41:41Z

5

I might have it. It seems I need to count a field inside the array instead of the array itself. This might just be because all I have are arrays of objects.

"script" : "doc['arrayField.objectField'].values.length"

answered Mar 15, 2013 at 17:41

Alden

3125 silver badges13 bronze badges

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

2 Comments

Alden Over a year ago

Ha, I did this and it totally killed my cluster. Maybe there is a way to do this with better performance.

imotov Over a year ago

It killed your cluster because it loaded all values of this field into memory and before version 0.90 elasticsearch was using quite inefficient structure to keep values for multi-valued fields in memory. So, you have a few options here: upgrade to 0.90.0.Beta1, use _fields instead of doc if this field is stored or to index the length of the array as another field. The last solution is the best in my opinion.

Collectives™ on Stack Overflow

How do I get the count/size of an array in elasticsearch

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related