Elasticsearch无痛脚本按值获取嵌套字段？

Question

{
  "title": "Mr",
  "first_name": "Barry",
  "last_name": "White",
  "experiences": [
     {
       "name": "parachute",
       "values": {
           "last_year": 4,
           "older": 12
       }
    },
    {
       "name": "base jump",
       "values": {
           "last_year": 2,
           "older": 1
       }
    }
   ]
}

以下是我的查询的简化版本：

{
"query" :{
    "nested": {
        "path": "experiences",
        "query":{
            "function_score" : {
                "functions": [
                    {
                        "filter": {"term": { "experiences.name": "parachute"} },
                        "script_score" : {
                            "script" : {
                              "lang": "painless",
                              "inline": "_score * doc['experiences.values.older'].value" //Here I want to get the "older" value of "parachute": 12
                            }
                        }
                    }
                ]
             }

        }
    }
}
}

希望有办法解决这个...

提前感谢你的帮助

Answer 1

我终于设法解决了这个问题，这要归功于官方elasticsearch IRC频道的一些帮助。我不得不稍微改变一下文档映射：

• 删除“值”
• 将“last_year”和“older”设置为每个经历的根值

就这样了。下面是最后一个查询：

{
    "query" :{
        "nested": {
            "path": "experiences",
            "query":{
                "function_score" : {
                    "query":{
                        "term": { "experiences.name": "parachute"}
                    },
                    "functions": [
                        {
                            "field_value_factor": {
                                "field": "experiences.older",
                                "factor": 1,
                                "missing": 1
                            }
                        },{
                            "field_value_factor": {
                                "field": "experiences.last_year",
                                "factor": 2,
                                "missing": 1

                            }
                        }
                    ],
                    "score_mode": "sum"
                }
            }
        }
    }
}