Elasticsearch使用脚本排序时出现错误

Question

目前我遇到了一个奇怪的问题：当我按照一个字段排序时，它会抛出异常：

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

有任何想法吗？

谢谢！

- milodky

Answer 1

这是一个与shell相关的问题。您需要转义单引号。 查询应该像这样 -

curl -XPOST 'http://localhost:9200/pb/p/_search' -d '{
  "query": {
    "match": {
      "first_name": "john"
    }
  },
  "sort": {
    "_script": {
      "script": "doc['"'"'dob_size'"'"'].value * factor1",
      "type": "number",
      "params": {
        "factor1": 1
      },
      "order": "desc"
    }
  }
}'

- Vineeth Mohan

---

谢谢！这就是我要找的。 - milodky