es根据字段长度过滤,ElasticSearch：根据字段长度过滤文档

I read couple of similar problems on SO and suggest solution not work..

I want to find all fields where word is shorter than 8

my database screen:

I tried to do this using this query

{

"query": {

"match_all": {}

},

"filter": {

"script": {

"script": "doc['word'].length < 5"

}

}

}

what I doing wrong? I miss something?

解决方案

Any field used in a script is loaded entirely into memory (http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/modules-scripting.html#_document_fields), so you may want to consider an alternative approach.

You can e.g. use the regexp-filter to just find terms of a certain length, with a pattern like .{0,4}.

#!/bin/bash

export ELASTICSEARCH_ENDPOINT="http://localhost:9200"

# Index documents

curl -XPOST "$ELASTICSEARCH_ENDPOINT/_bulk?refresh=true" -d '

{"index":{"_index":"play","_type":"type"}}

{"word":"bar"}

{"index":{"_index":"play","_type":"type"}}

{"word":"barf"}

{"index":{"_index":"play","_type":"type"}}

{"word":"zip"}

'

# Do searches

# This will not match barf

curl -XPOST "$ELASTICSEARCH_ENDPOINT/_search?pretty" -d '

{

"query": {

"filtered": {

"filter": {

"regexp": {

"word": {

"value": ".{0,3}"

}

}

}

}

}

}

'