目前我遇到了一个奇怪的问题:当我按照一个字段排序时,它会抛出异常:
curl -XGET 'http://localhost:9200/pb/p/_search?pretty' -d '{
"query": {"match" : {"first_name" : "john"}},
"sort" : {
"_script" : {
"script" : "doc['dob_size'].value * factor1",
"type" : "number",
"params" : {"factor1" : 1},
"order" : "desc"
}}}'
{
"took" : 5,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 1,
"failed" : 4,
"failures" : [ {
"index" : "pb",
"shard" : 0,
"status" : 500,
"reason" : "QueryPhaseExecutionException[[pb][0]: query[filtered(first_name:john)->cache(_type:p)],from[0],size[10],sort[<custom:\"_script\": org.elasticsearch.search.sort.ScriptSortParser$2@7ac5f844>!]: Query Failed [Failed to execute main query]]; nested: GroovyScriptExecutionException[MissingPropertyException[No such property: dob_size for class: Script132]]; "
}, {
"index" : "pb",
"shard" : 2,
"status" : 500,
"reason" : "QueryPhaseExecutionException[[pb][2]: query[filtered(first_name:john)->cache(_type:p)],from[0],size[10],sort[<custom:\"_script\": org.elasticsearch.search.sort.ScriptSortParser$2@12127900>!]: Query Failed [Failed to execute main query]]; nested: GroovyScriptExecutionException[MissingPropertyException[No such property: dob_size for class: Script132]]; "
}, {
"index" : "pb",
"shard" : 3,
"status" : 500,
"reason" : "QueryPhaseExecutionException[[pb][3]: query[filtered(first_name:john)->cache(_type:p)],from[0],size[10],sort[<custom:\"_script\": org.elasticsearch.search.sort.ScriptSortParser$2@5b2e7754>!]: Query Failed [Failed to execute main query]]; nested: GroovyScriptExecutionException[MissingPropertyException[No such property: dob_size for class: Script132]]; "
}, {
"index" : "pb",
"shard" : 4,
"status" : 500,
"reason" : "QueryPhaseExecutionException[[pb][4]: query[filtered(first_name:john)->cache(_type:p)],from[0],size[10],sort[<custom:\"_script\": org.elasticsearch.search.sort.ScriptSortParser$2@5dd9cdc1>!]: Query Failed [Failed to execute main query]]; nested: GroovyScriptExecutionException[MissingPropertyException[No such property: dob_size for class: Script132]]; "
} ]
},
"hits" : {
"total" : 0,
"max_score" : null,
"hits" : [ ]
}
}
然而,当我删除排序部分时,它就完美地工作:
curl -XGET 'http://localhost:9200/pb/p/_search?pretty' -d '{
"query": {"match" : {"first_name" : "john"}}}'
{
"took" : 3,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
},
"hits" : {
"total" : 4,
"max_score" : 0.30685282,
"hits" : [ {
"_index" : "pb",
"_type" : "p",
"_id" : "4",
"_score" : 0.30685282,
"_source":{
"first_name" : ["john", "jon"],
"last_name" : "abcdef",
"location_size": 3,
"relative_size": 3,
"dob_size" : 1}
}, {
"_index" : "pb",
"_type" : "p",
"_id" : "1",
"_score" : 0.30685282,
"_source":{
"first_name" : ["john", "jon"],
"last_name" : "abcdef",
"location_size": 5,
"relative_size": 3,
"dob_size" : 1}
}, {
"_index" : "pb",
"_type" : "p",
"_id" : "2",
"_score" : 0.30685282,
"_source":{
"first_name" : ["john", "jon"],
"last_name" : "abcdef",
"location_size": 5,
"relative_size": 4,
"dob_size" : 0}
}, {
"_index" : "pb",
"_type" : "p",
"_id" : "3",
"_score" : 0.30685282,
"_source":{
"first_name" : ["john", "jon"],
"last_name" : "abcdef",
"location_size": 5,
"relative_size": 4,
"dob_size" : 1}
} ]
}
}
我按照这里的指南进行操作,但似乎没有效果。
映射如下:
curl -XGET 'http://localhost:9200/pb/p/_mapping?pretty'
{
"pb" : {
"mappings" : {
"p" : {
"properties" : {
"dob_size" : {
"type" : "integer"
},
"first_name" : {
"type" : "string",
"index" : "not_analyzed"
},
"last_name" : {
"type" : "string",
"index" : "not_analyzed"
},
"location_size" : {
"type" : "integer"
},
"relative_size" : {
"type" : "integer"
}
}
}
}
}
}
而且elasticsearch的版本是:./elasticsearch -v 版本:1.4.1,构建:89d3241/2014-11-26T15:49:29Z,JVM:1.7.0_55
有任何想法吗?
谢谢!