Statistical facet on length of string field

Elastic Stack Elasticsearch
4

Oh, I found out! I was supposed to use length(). Thanks a lot, you pointed
me in the right direction! :slight_smile:

On Saturday, April 12, 2014 4:15:59 PM UTC+2, CC wrote:

Thank you very much for your reply. I tried using script fields, like
this:

"query":{
"match_all": {}
},
"script_fields":{
"test1":{
"script": "_source.title.length"}
}
}

but my issue now is that I get "PropertyAccessException: Could not access
length". My title field is of type string and I was expecting Elasticsearch
to know about it. I am also using CURL for queries, is there any way to
overcome this error?

Thank you,
Cristina

On Saturday, April 12, 2014 2:50:04 PM UTC+2, vineeth mohan wrote:

Hello Cristina ,

This is not possible using stat facet. It expect the field to be a number
and it calculates max/min etc based on its different values.

A way to do this would be to add a new field while indexing which would
be the length of the title.
Then performing stats over it might work.

There might be other solutions based on scripting , but i need to explore
...

Thanks
Vineeth

On Sat, Apr 12, 2014 at 3:25 PM, Cristina Garbacea <cr1st1na...@gmail.com

wrote:

I would like to retrieve statistical data about a string field like the
min, max and average length (by counting the number of characters inside
the string). I am using CURL to do this and I have what I have tried so far

"query":{
"match_all": {}
},
"facets":{
"stats":{
"statistical":{
"field":"title"}
}
}

returns me exception because the facet expects a number field. How can I
achieve my goal? Thanks!

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/3c1a08f2-e467-47c3-a667-43837ac9b352%40googlegroups.comhttps://groups.google.com/d/msgid/elasticsearch/3c1a08f2-e467-47c3-a667-43837ac9b352%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/8fbb42c1-636b-41f6-b22d-4e4bbaf21719%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.