es根据字段长度过滤,elasticsearch按字符串字段的长度过滤

i am trying to get records the has in 'title' more then X characters.

NOTE: not all records contains title field.

i have tried:

GET books/_search

{

"filter" : {

"script" : {

"script" : "_source.title.length() > 10"

}

}

}

as a result, i get this error:

GroovyScriptExecutionException[NullPointerException[Cannot invoke method length() on null object

how can i solve it?

解决方案

You need to take into account that some documents might have a null title field. So you can use the groovy null-safe operator. Also make sure to use the POST method instead:

POST books/_search

{

"filter" : {

"script" : {

"script" : "_source.title?.size() > 10"

}

}

}