Elasticsearch Painless脚本报错：无法将[int]转换为[def[]]

我尝试用Painless脚本给employee_code字段的整数添加前导零以实现排序，使用的查询脚本如下：

{
  "query": {
    "match_all": {}
  },
  "sort": {
    "_script": {
      "type": "string",
      "script": {
        "source": """
          int paddingWidth = 10;
          def value = doc['employee_code.keyword'].value;
          if (value == null) return "";
          boolean isNumeric = true;
          if (isNumeric) {
            int temp = 2;
            return String.format('%010d', temp);
          } else {
            return value;
          }
        """,
        "lang": "painless"
      },
      "order": "asc"
    }
  }
}

运行后出现如下错误：

{
  "error" : {
    "root_cause" : [
      {
        "type" : "script_exception",
        "reason" : "compile error",
        "script_stack" : [
          "... n String.format('%010d', temp);\n          } else { ...",
          "                             ^---- HERE"
        ],
        "script" : "\n          int paddingWidth = 10;\n          def value = doc['employee_code.keyword'].value;\n          if (value == null) return \"\";\n          boolean isNumeric = true;\n          if (isNumeric) {\n            int temp = 2;\n            return String.format('%010d', temp);\n          } else {\n            return value;\n          }\n        ",
        "lang" : "painless",
        "position" : {
          "offset" : 263,
          "start" : 238,
          "end" : 288
        }
      }
    ],
    "type" : "search_phase_execution_exception",
    "reason" : "all shards failed",
    "phase" : "query",
    "grouped" : true,
    "failed_shards" : [
      {
        "shard" : 0,
        "index" : "search_psr_core_index",
        "node" : "govZA-NHQyStPH2nWOujMQ",
        "reason" : {
          "type" : "script_exception",
          "reason" : "compile error",
          "script_stack" : [
            "... n String.format('%010d', temp);\n          } else { ...",
            "                             ^---- HERE"
          ],
          "script" : "\n          int paddingWidth = 10;\n          def value = doc['employee_code.keyword'].value;\n          if (value == null) return \"\";\n          boolean isNumeric = true;\n          if (isNumeric) {\n            int temp = 2;\n            return String.format('%010d', temp);\n          } else {\n            return value;\n          }\n        ",
          "lang" : "painless",
          "position" : {
            "offset" : 263,
            "start" : 238,
            "end" : 288
          },
          "caused_by" : {
            "type" : "class_cast_exception",
            "reason" : "Cannot cast from [int] to [def[]]."
          }
        }
      }
    ]
  },
  "status" : 400
}

解决方法 #

错误原因 #

Painless中String.format()方法的第二个参数要求是对象数组，而非单个值，直接传入int类型的temp会触发类型转换错误，这是报错的核心原因。另外原脚本中isNumeric变量硬编码为true，未实际判断字段值是否为数字，逻辑存在漏洞。

修正后的脚本 #

{
  "query": {
    "match_all": {}
  },
  "sort": {
    "_script": {
      "type": "string",
      "script": {
        "source": """
          int paddingWidth = 10;
          def value = doc['employee_code.keyword'].value;
          if (value == null) return "";
          // 判断字符串是否为纯数字
          boolean isNumeric = value.matches('^[0-9]+$');
          if (isNumeric) {
            try {
              int num = Integer.parseInt(value);
              // 将参数包装为数组传递给format方法
              return String.format('%0' + paddingWidth + 'd', new Object[]{num});
            } catch (NumberFormatException e) {
              // 转换失败时返回原字符串
              return value;
            }
          } else {
            return value;
          }
        """,
        "lang": "painless"
      },
      "order": "asc"
    }
  }
}

关键修正点 #

• 调整String.format参数形式：用new Object[]{num}将单个参数包装为数组，符合Painless方法参数要求
• 实现真实数字判断：通过value.matches('^[0-9]+$')检查字符串是否为纯数字
• 添加异常捕获：避免字符串转整数时出现转换失败的情况
• 动态拼接格式化字符串：使用paddingWidth变量生成格式化规则，提升脚本灵活性

内容的提问来源于stack exchange，提问作者Avinash A