Es 7.x版本批量写入数据路由字段报错:Action/metadata line [1] contains an unknown parameter [_routing] 原创 2021-03-02 19:02:34.0 阅读(3904)次 #### 异常问题 在使用elasticsearch7版本批量插入数据时,因为设置了路由,一直报错:Action/metadata line [1] contains an unknown parameter [_routing] 具体错误信息如下: ```json {"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"Action/metadata line [1] contains an unknown parameter [_routing]"}],"type":"illegal_argument_exception","reason":"Action/metadata line [1] contains an unknown parameter [_routing]"},"status":400} ``` 批量写入的DSL语句如下: ```json PUT /_bulk {"index":{"_id":"1","_index":"bd_frequent_test","_routing":"1222930"}} {"ape_id":"949","appear_num":1,"create_time":"2019-12-28 00:46:08","event_time":"2019-12-28","id":1,"last_event_time":"2019-12-28 00:46:08","pid":"1222930","storage_date":"2019-12-28"} {"index":{"_id":"2","_index":"bd_frequent_test","_routing":"5031160"}} {"ape_id":"711","appear_num":1,"create_time":"2019-12-29 11:06:39","event_time":"2019-12-29","id":2,"last_event_time":"2019-12-29 11:06:39","pid":"5031160","storage_date":"2019-12-29"} {"index":{"_id":"3","_index":"bd_frequent_test","_routing":"3094889"}} {"ape_id":"350","appear_num":1,"create_time":"2019-12-28 19:21:07","event_time":"2019-12-28","id":3,"last_event_time":"2019-12-28 19:21:07","pid":"3094889","storage_date":"2019-12-28"} {"index":{"_id":"4","_index":"bd_frequent_test","_routing":"2974413"}} {"ape_id":"684","appear_num":1,"create_time":"2019-12-29 22:36:06","event_time":"2019-12-29","id":4,"last_event_time":"2019-12-29 22:36:06","pid":"2974413","storage_date":"2019-12-29"} {"index":{"_id":"5","_index":"bd_frequent_test","_routing":"5819906"}} {"ape_id":"97","appear_num":1,"create_time":"2019-12-29 04:27:55","event_time":"2019-12-29","id":5,"last_event_time":"2019-12-29 04:27:55","pid":"5819906","storage_date":"2019-12-29"} {"index":{"_id":"6","_index":"bd_frequent_test","_routing":"6812661"}} ``` 这个语句之前在es7之前的版本,也就是es6.x版本时是可以批量写入的,但在7就报错了。 #### 解决办法 原来问题出在7的批量写入时,路由字段改成了routing,没有下划线。 将批量写入语句如下,就可以了: ```json PUT /_bulk {"index":{"_id":"1","_index":"bd_frequent_test","routing":"1222930"}} {"ape_id":"949","appear_num":1,"create_time":"2019-12-28 00:46:08","event_time":"2019-12-28","id":1,"last_event_time":"2019-12-28 00:46:08","pid":"1222930","storage_date":"2019-12-28"} {"index":{"_id":"2","_index":"bd_frequent_test","routing":"5031160"}} {"ape_id":"711","appear_num":1,"create_time":"2019-12-29 11:06:39","event_time":"2019-12-29","id":2,"last_event_time":"2019-12-29 11:06:39","pid":"5031160","storage_date":"2019-12-29"} {"index":{"_id":"3","_index":"bd_frequent_test","routing":"3094889"}} {"ape_id":"350","appear_num":1,"create_time":"2019-12-28 19:21:07","event_time":"2019-12-28","id":3,"last_event_time":"2019-12-28 19:21:07","pid":"3094889","storage_date":"2019-12-28"} {"index":{"_id":"4","_index":"bd_frequent_test","routing":"2974413"}} {"ape_id":"684","appear_num":1,"create_time":"2019-12-29 22:36:06","event_time":"2019-12-29","id":4,"last_event_time":"2019-12-29 22:36:06","pid":"2974413","storage_date":"2019-12-29"} ``` elasticsearch 异常处理 上一篇:Es创建索引mapping时报错:Root mapping definition has unsupported parameters: [doc 下一篇:es7.x版本如何获取查询命中的文档总数
相关文章 elasticsearch7.1保存时报错: Validation Failed: 1: type is missing;(11082) Es创建索引mapping时报错:Root mapping definition has unsupported parameters: [doc(8797) windows nginx启动报错bind() to 0.0.0.0:80 failed (2154) 记一次maven报错解决:Failed to read artifact descriptor for com.aliyun.openservices:aliyun-openservices:jar:2.0.0-OTS(5906) Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect(2883) solr搜索报错:Error from server at http://127.0.0.1:8983/solr/索引名: undefined field text(5562) java.lang.ClassNotFoundException: org.springframework.web.context.ContextLoaderListener(1379) es聚合之实现日期按周一到周日的聚合统计(5128) ES各版本的新特性官网地址(2246) es7.x版本如何获取查询命中的文档总数(4599) 推荐文章 elasticsearch7.1保存时报错: Validation Failed: 1: type is missing;(7) 聊聊数据保存到MySQL后数据乱码的问题(1) solr时区设置解决时间多8小时问题(1) linux下MySQL5.7.18安装过程(1) linux下MySQL5.6.2安装过程(1) spring cloud+feign+mybatis中使用seata0.9实现分布式事务(7) spring cloud gateway报错Only one connection receive subscriber allowed(82) spring cloud中Feign调用诡异报错MethodNotAllowed: status 405 reading(116) 使用spring4实现websocket连接(1) jquery对象与dom对象互转(1) 热门文章 clickhouse如何删除数据(40016) clickhouse清空删除表数据(18228) redis报错远程主机强迫关闭了一个现有的连接以及超时问题(16275) clickhouse执行查询内存超出限制问题:Memory limit (total) exceeded(14617) elasticsearch7.1保存时报错: Validation Failed: 1: type is missing;(11061) clickhouse如何修改字段名(9931) druid执行clickhouse报错:sql injection violation, dbType clickhouse , druid-version 1.2.2, syntax error(8915) Es创建索引mapping时报错:Root mapping definition has unsupported parameters: [doc(8786) Clickhouse批量删除分区(8708) postgresql生成uuid(8257) 标签列表 java java java基础 java基础 微服务 异常处理 mysql spring boot spring cloud clickhouse clickhouse clickhouse clickhouse linux elasticsearch feign jdbc js spring postgresql docker 格子衫 程序员 seata solr nginx 程序员 格子衫 maven gateway hsqldb 数据库 架构 大数据分析 分布式事务 canal redis dubbo 消息队列 win10 websocket springmvc git hadoop mybatis jenkins quartz rocketmq select2 html 阿里云 设计模式 笔记 eclipse freemarker 电脑 bat 格子衫 ajax 数据库集群 activemq jvm jquery javamail hystrix redission redission对象 http hibernate springmail svn ubuntu ueditor xheditor zookeeper 分布式 小程序 开发工具 gitlab github