企业🤖AI智能体构建引擎,智能编排和调试,一键部署,支持私有化部署方案 广告
## 1. 基础排序 1. 默认排序规则 默认情况下,是按照_score降序排序的,然而,某些情况下,可能没有有用的_score,比如说filter ~~~ GET /_search { "query" : { "bool" : { "filter" : { "term" : { "author_id" : 1 } } } } } ~~~ 当然,也可以是constant_score,只使用过滤器 ~~~ GET /_search { "query" : { "constant_score" : { "filter" : { "term" : { "author_id" : 1 } } } } } ~~~ 2. 自定义排序规则 query后边跟sort ~~~ GET /company/employee/_search { "query": { "constant_score": { "filter": { "range": { "age": { "gte": 30 } } } } }, "sort": [ { "join_date": { # 指定要排序的field "order": "asc" } } ] } ~~~ ## 2. string字段排序 1. 对一个字段,指定一个用于搜索,一个用于排序 如果对一个string field进行排序,结果往往不准确,因为分词后是多个单词,再排序就不是我们想要的结果了 通常解决方案是,将一个string field建立两次索引,一个分词,用来进行搜索;一个不分词,用来进行排序 ~~~ PUT /website { "mappings": { "article": { "properties": { "title": { "type": "text", "fields": { "raw": { "type": "string", "index": "not_analyzed" # 不分词 } }, "fielddata": true # 正排索引 }, "content": { "type": "text" }, "post_date": { "type": "date" }, "author_id": { "type": "long" } } } } } PUT /website/article/1 { "title": "first article", "content": "this is my second article", "post_date": "2017-01-01", "author_id": 110 } { "took": 2, "timed_out": false, "_shards": { "total": 5, "successful": 5, "failed": 0 }, "hits": { "total": 3, "max_score": 1, "hits": [ { "_index": "website", "_type": "article", "_id": "2", "_score": 1, "_source": { "title": "first article", "content": "this is my first article", "post_date": "2017-02-01", "author_id": 110 } }, { "_index": "website", "_type": "article", "_id": "1", "_score": 1, "_source": { "title": "second article", "content": "this is my second article", "post_date": "2017-01-01", "author_id": 110 } }, { "_index": "website", "_type": "article", "_id": "3", "_score": 1, "_source": { "title": "third article", "content": "this is my third article", "post_date": "2017-03-01", "author_id": 110 } } ] } } GET /website/article/_search { "query": { "match_all": {} }, "sort": [ { "title.raw": { "order": "desc" } } ] } ~~~