如何在不更改设置的情况下不区分大小写排序

我的索引名称是 data_new

下面是插入索引的代码

test = [   {'id':1,'name': 'A', 'professor': ['Bill Cage', 'accounting']},
    { 'id':2,  'name': 'AB', 'professor': ['Gregg Payne', 'engineering']},
    {'id':3,   'name': 'a',   'professor': ['Bill Cage', 'accounting']},
    {'id':4,'name': 'Tax Accounting 200', 'professor': ['Thomas Baszo', 'finance']},
    {'id':5,'name': 'Capital Markets 350', 'professor': ['Thomas Baszo', 'finance']},
    {'id':6,'name': 'Theatre 410', 'professor': ['Sebastian Hern', 'art']},
    {'id':7,'name': 'Accounting 101', 'professor': ['Thomas Baszo', 'finance']},
    {'id':8,'name': 'Marketing 101', 'professor': ['William Smith', 'finance']},
    {'id':8,'name': 'Anthropology 230', 'professor': ['Devin Cranford', 'history']},
    {'id':10,   'name': 'Computer Science 101',
        'professor': ['Gregg Payne', 'engineering']}]
from elasticsearch import Elasticsearch
import json
es = Elasticsearch()
es.indices.create(index='data_new', ignore=400)
for e in test:
        es.index(index="data_new", body=e, id=e['id'])
search = es.search(index="data_new", body={"from" : 0, "size" : 2,"query": {"match_all": {}}})
search['hits']['hits']

现在

[{'id':1,'name': 'A'},
{ 'id':2,  'name': 'AB'},
{'id':3,   'name': 'a'}]

预计按以下顺序排列

[{'id':1,'name': 'A'},
{ 'id':3,  'name': 'a'},
{'id':2,   'name': 'AB'}]

用于输入["a", "b", "B", "C", "c", "A"] 结果是： ["A", "B", "C", "a", "b", "c"]

我想要输出为["A", "a", "B", "b", "C", "c"]

预计出

我的第一个预期输出 > 我需要仅在 {Case insensitive} 中根据名称对输出进行排序。我需要规范名称关键字并排序

如何进行修改search = es.search(index="data_new", body={"from" : 0, "size" : 2,"query": {"match_all": {}}})

我已经用下面的代码更新了search = es.search(index="data_new", body={ "sort" : [{"name.keyword" : {"order" : "asc"}], {"size": 1000, "query": {"query_string": {"query": "A"}}})

with "normalizer": "case_insensitive"}我收到错误

RequestError: RequestError(400, 'x_content_parse_exception', '[1:41] [field_sort] unknown field [normalizer]')

为了做到这一点，你必须使用一个脚本ctx._source.mykey.toLowerCase() https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-sort-context.html https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-sort-context.html

你可以找到另一篇讨论它的帖子：Elasticsearch 日期字段基于脚本的排序 https://stackoverflow.com/questions/32933085/script-based-sorting-on-elasticsearch-date-field还有一篇很好的文章，这里有一个例子：https://qbox.io/blog/how-to-painless-scripting-in-elasticsearch https://qbox.io/blog/how-to-painless-scripting-in-elasticsearch

代码看起来像（未测试）

{
 "query": {
   "match_all": {}
 },
 "sort": {
   "_script": {
     "type": "string",
     "order": "asc",
     "script": {
       "lang": "painless",
       "inline": "doc['name.keyword'].value.toLowerCase()"
     }
   }
 }
}

注意：这是一种不好的做法，您应该只针对一次性查询执行此操作。如果您希望您的应用程序保持健康，您应该实施 saeednasehi 建议的解决方案。 您还可以使用索引排序来提高性能。