#### 异常问题
在使用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"}
```

ClassInstance

Es 7.x版本批量写入数据路由字段报错:Action/metadata line [1] contains an unknown parameter [_routing]

相关文章

推荐文章

热门文章

标签列表