Elasticsearch 根据 _id 排序
我这里有一个测试索引数据如下：
如果用普通的排序方法对_id中的数据进行排序的话：
GET _search{"query": {"term": {"_index": "test"}},"sort": {"_id": {"order": "asc"}},"size": 20}
因为_id的数据为字符串类型，因此排序出来的结果其实并不是我们想要的：
{"took" : 5,"timed_out" : false,"_shards" : {"total" : 10,"successful" : 10,"skipped" : 9,"failed" : 0},"hits" : {"total" : {"value" : 19,"relation" : "eq"},"max_score" : null,"hits" : [{"_index" : "test","_type" : "_doc","_id" : "1","_score" : null,"_source" : { },"sort" : ["1"]},{"_index" : "test","_type" : "_doc","_id" : "10","_score" : null,"_source" : { },"sort" : ["10"]},{"_index" : "test","_type" : "_doc","_id" : "11","_score" : null,"_source" : { },"sort" : ["11"]},{"_index" : "test","_type" : "_doc","_id" : "12","_score" : null,"_source" : { },"sort" : ["12"]},{"_index" : "test","_type" : "_doc","_id" : "13","_score" : null,"_source" : { },"sort" : ["13"]},{"_index" : "test","_type" : "_doc","_id" : "14","_score" : null,"_source" : { },"sort" : ["14"]},{"_index" : "test","_type" : "_doc","_id" : "15","_score" : null,"_source" : { },"sort" : ["15"]},{"_index" : "test","_type" : "_doc","_id" : "16","_score" : null,"_source" : { },"sort" : ["16"]},{"_index" : "test","_type" : "_doc","_id" : "17","_score" : null,"_source" : { },"sort" : ["17"]},{"_index" : "test","_type" : "_doc","_id" : "18","_score" : null,"_source" : { },"sort" : ["18"]},{"_index" : "test","_type" : "_doc","_id" : "19","_score" : null,"_source" : { },"sort" : ["19"]},{"_index" : "test","_type" : "_doc","_id" : "2","_score" : null,"_source" : { },"sort" : ["2"]},{"_index" : "test","_type" : "_doc","_id" : "3","_score" : null,"_source" : { },"sort" : ["3"]},{"_index" : "test","_type" : "_doc","_id" : "4","_score" : null,"_source" : { },"sort" : ["4"]},{"_index" : "test","_type" : "_doc","_id" : "5","_score" : null,"_source" : { },"sort" : ["5"]},{"_index" : "test","_type" : "_doc","_id" : "6","_score" : null,"_source" : { },"sort" : ["6"]},{"_index" : "test","_type" : "_doc","_id" : "7","_score" : null,"_source" : { },"sort" : ["7"]},{"_index" : "test","_type" : "_doc","_id" : "8","_score" : null,"_source" : { },"sort" : ["8"]},{"_index" : "test","_type" : "_doc","_id" : "9","_score" : null,"_source" : { },"sort" : ["9"]}]}}
他会先对字符串的第一个字符进行排序，在依次对后面的字符进行排序。
想要对 String 类型的 _id 进行数字顺序排序，就需要用到排序脚本：
因此可以这样写：
GET _search{"query": {"term": {"_index": "test"}},"sort": {"_script": {"type": "number","script": "Integer.parseInt(doc['_id'].value)","order": "asc"}},"size": 20}
看看结果：
{"took" : 5,"timed_out" : false,"_shards" : {"total" : 10,"successful" : 10,"skipped" : 0,"failed" : 0},"hits" : {"total" : {"value" : 19,"relation" : "eq"},"max_score" : null,"hits" : [{"_index" : "test","_type" : "_doc","_id" : "1","_score" : null,"_source" : { },"sort" : [1.0]},{"_index" : "test","_type" : "_doc","_id" : "2","_score" : null,"_source" : { },"sort" : [2.0]},{"_index" : "test","_type" : "_doc","_id" : "3","_score" : null,"_source" : { },"sort" : [3.0]},{"_index" : "test","_type" : "_doc","_id" : "4","_score" : null,"_source" : { },"sort" : [4.0]},{"_index" : "test","_type" : "_doc","_id" : "5","_score" : null,"_source" : { },"sort" : [5.0]},{"_index" : "test","_type" : "_doc","_id" : "6","_score" : null,"_source" : { },"sort" : [6.0]},{"_index" : "test","_type" : "_doc","_id" : "7","_score" : null,"_source" : { },"sort" : [7.0]},{"_index" : "test","_type" : "_doc","_id" : "8","_score" : null,"_source" : { },"sort" : [8.0]},{"_index" : "test","_type" : "_doc","_id" : "9","_score" : null,"_source" : { },"sort" : [9.0]},{"_index" : "test","_type" : "_doc","_id" : "10","_score" : null,"_source" : { },"sort" : [10.0]},{"_index" : "test","_type" : "_doc","_id" : "11","_score" : null,"_source" : { },"sort" : [11.0]},{"_index" : "test","_type" : "_doc","_id" : "12","_score" : null,"_source" : { },"sort" : [12.0]},{"_index" : "test","_type" : "_doc","_id" : "13","_score" : null,"_source" : { },"sort" : [13.0]},{"_index" : "test","_type" : "_doc","_id" : "14","_score" : null,"_source" : { },"sort" : [14.0]},{"_index" : "test","_type" : "_doc","_id" : "15","_score" : null,"_source" : { },"sort" : [15.0]},{"_index" : "test","_type" : "_doc","_id" : "16","_score" : null,"_source" : { },"sort" : [16.0]},{"_index" : "test","_type" : "_doc","_id" : "17","_score" : null,"_source" : { },"sort" : [17.0]},{"_index" : "test","_type" : "_doc","_id" : "18","_score" : null,"_source" : { },"sort" : [18.0]},{"_index" : "test","_type" : "_doc","_id" : "19","_score" : null,"_source" : { },"sort" : [19.0]}]}}
搞定！
版权说明 : 本文为转载文章, 版权归原作者所有 版权申明
原文链接 : https://blog.csdn.net/qq_43613793/article/details/121735292
内容来源于网络，如有侵权，请联系作者删除！