ES ： Can't get text on a START_OBJECT at 1.225

ES批量更新与pushDetail字段映射问题

最新推荐文章于 2025-09-13 21:23:16 发布

原创最新推荐文章于 2025-09-13 21:23:16 发布 · 1.4w 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#error #问题 #报错

ElasticSearch 专栏收录该内容

28 篇文章

订阅专栏

解决ES环境中批量更新数据时遇到的Can'tgettextonaSTART_OBJECT错误，涉及pushDetail字段mapping类型冲突，从keyword改为Object类型，或调整DSL语句以匹配字符串类型数据。

pre 环境，批量更新，遇到错误： "Can't get text on a START_OBJECT at 1:225"

无法解析字段 pushDetail 。mapping 中 pushDetail 字段是keyword 类型，所有应该传字符串类型的数据。业务传的是 json 格式的数据，故报此错。

解决方案：

1、修改 pushDetail 字段 mapping 为 Object 类型；

2、传字符串类型，修改更新 DSL 语句：

POST /sn_data_analysis/data_detail/_update_by_query
{
  "query": {
        "bool": {
            "must": [
                {"term": {"appCode": "SNYG"}},
{"term": {"activityId": "TEST160735"}}
            ]
        }
    },
  "script": {
    "inline": "ctx._source.pushDetail = params.pushDetail",
     "params": {
            "pushDetail": ["{\"count\":0,\"type\":1}","{\"count\":0,\"type\":2}","{\"count\":0,\"type\":3}","{\"count\":0,\"type\":4}","{\"count\":0,\"type\":5}","{\"count\":0,\"type\":6}","{\"count\":0,\"type\":7}","{\"count\":0,\"type\":8}","{\"count\":0,\"type\":21}","{\"count\":0,\"type\":9}","{\"count\":0,\"type\":10}","{\"count\":0,\"type\":11}","{\"count\":0,\"type\":12}","{\"count\":0,\"type\":13}","{\"count\":0,\"type\":14}","{\"count\":0,\"type\":19}","{\"count\":0,\"type\":20}","{\"count\":0,\"type\":15}","{\"count\":0,\"type\":17}","{\"count\":0,\"type\":16}","{\"count\":0,\"type\":18}","{\"count\":0,\"type\":22}","{\"count\":0,\"type\":25}","{\"count\":0,\"type\":26}","{\"count\":0,\"type\":27}","{\"count\":0,\"type\":28}","{\"count\":0,\"type\":29}","{\"count\":0,\"type\":30}"]
        },
    "lang": "painless"
  }
}

PS ：批量更新，不支持 doc 更新模式