弹性搜索排序

Question

我的数据排序后是这样的:以下是排序后的响应。但这并不是预期的输出。

{
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 5,
        "successful": 5,
        "failed": 0
    },
    "hits": {
        "total": 8,
        "max_score": null,
        "hits": [
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVTy-v9pbhY5QtJPGe",
                "_score": null,
                "_source": {
                    "e_size": "5"
                },
                "sort": [
                    "5"
                ]
            },
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVTmY89pbhY5QtJPGa",
                "_score": null,
                "_source": {
                    "e_size": "3"
                },
                "sort": [
                    "3"
                ]
            },
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVTxXe9pbhY5QtJPGd",
                "_score": null,
                "_source": {
                    "e_size": "100"
                },
                "sort": [
                    "100"
                ]
            },
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVTpYJ9pbhY5QtJPGc",
                "_score": null,
                "_source": {
                    "e_size": "10-"
                },
                "sort": [
                    "10-"
                ]
            },
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVTk1x9pbhY5QtJPGY",
                "_score": null,
                "_source": {
                    "e_size": "1-7"
                },
                "sort": [
                    "1-7"
                ]
            },
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVTnsm9pbhY5QtJPGb",
                "_score": null,
                "_source": {
                    "e_size": "1-6"
                },
                "sort": [
                    "1-6"
                ]
            },
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVTjAq9pbhY5QtJPGX",
                "_score": null,
                "_source": {
                    "e_size": "1-2"
                },
                "sort": [
                    "1-2"
                ]
            },
            {
                "_index": "test",
                "_type": "size",
                "_id": "AWVVThkT9pbhY5QtJPGW",
                "_score": null,
                "_source": {
                    "e_size": "1"
                },
                "sort": [
                    "1"
                ]
            }
        ]
    }
}

下面是用于获得结果的排序。

 {
     "sort": [{
         "e_size": {
             "order": "desc"

         }
     }]
 }

e_size类型为"String“，索引为"not_analyzed”

如何解决这个排序问题。我们需要使用任何分析器来做这个吗。或者e_size数据类型应该不同。

Answer 1

它已经正确地对它进行了排序。您可以尝试自己对这些字符串进行排序，也会得到相同的结果。

示例：["100", "10-"]

这里是"0" < "-"，这就是为什么"10-"在"100"之后，以此类推。你可以把它看作是如何在字典中找到一些单词。

将e_size设置为数字或对每个e_size使用任何不同的字符串系列