ElasticSearch script查询报错Variable [field] is not defined-Toy模板网

这篇具有很好参考价值的文章主要介绍了ElasticSearch script查询报错Variable [field] is not defined。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

ES版本7.6.0
想筛选某两个字段之和大于10的文档，需要用到脚本，简化的请求如下

{
  "query":
  {
    "bool":
    {
      "must":
      [
        {
          "script":
          {
            "script": "doc['field'].value >= 1"
          }
        }
      ]
    }
  }
}

报错提示field未定义，报错详情

{
  "error" : {
    "root_cause" : [
      {
        "type" : "script_exception",
        "reason" : "compile error",
        "script_stack" : [
          "doc[field]. ...",
          "    ^---- HERE"
        ],
        "script" : "doc[field].value >= 1",
        "lang" : "painless"
      }
    ],
    "type" : "search_phase_execution_exception",
    "reason" : "all shards failed",
    "phase" : "query",
    "grouped" : true,
    "failed_shards" : [
      {
        "shard" : 0,
        "index" : "...",
        "node" : "...",
        "reason" : {
          "type" : "query_shard_exception",
          "reason" : "failed to create query: ...",
          "index_uuid" : "...",
          "index" : "...",
          "caused_by" : {
            "type" : "script_exception",
            "reason" : "compile error",
            "script_stack" : [
              "doc[field]. ...",
              "    ^---- HERE"
            ],
            "script" : "doc[field].value >= 1",
            "lang" : "painless",
            "caused_by" : {
              "type" : "illegal_argument_exception",
              "reason" : "Variable [field] is not defined."
            }
          }
        }
      }
    ],
    "caused_by" : {
      "type" : "script_exception",
      "reason" : "compile error",
      "script_stack" : [
        "doc[field]. ...",
        "    ^---- HERE"
      ],
      "script" : "doc[field].value >= 1",
      "lang" : "painless",
      "caused_by" : {
        "type" : "illegal_argument_exception",
        "reason" : "Variable [field] is not defined."
      }
    }
  },
  "status" : 400
}

解决方法：改用双引号包裹包裹字段名文章来源地址https://www.toymoban.com/news/detail-722303.html

{
  "query":
  {
    "bool":
    {
      "must":
      [
        {
          "script":
          {
            "script": "doc[\"field\"].value >= 1"
          }
        }
      ]
    }
  }
}