elasticsearch使用Sort排序时Please use a keyword field instead.

具体报错信息

ElasticsearchStatusException[Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]]; nested: ElasticsearchException[Elasticsearch exception [type=illegal_argument_exception, reason=Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [recordTime] in order to load field data by uninverting the inverted index. Note that this can use significant memory.]]; nested: ElasticsearchException[Elasticsearch exception [type=illegal_argument_exception, reason=Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [recordTime] in order to load field data by uninverting the inverted index. Note that this can use significant memory.]];

原因是在使用es查询的时候使用了orderby.

核心提示在Please use a keyword field instead. Alternatively, set fielddata=true on [recordTime] in order to load field data by uninverting the inverted index.

待排序字段recordTime没有为排序优化,所以无法排序,需要配置FieldType.Keywordfielddata = true

给对应的字段加上注解,这里使用的是easy-es,注解有所不同

    @IndexField(fieldType = FieldType.KEYWORD)
    private LocalDateTime recordTime;

项目启动后会自动在ElasticSearch创建索引,查询索引信息,有mapping才说明注解配置生效了,因为注解声明的字段信息在ElasticSearch对应的就是mapping

刷新索引可以看到
image

posted @   leepandar  阅读(70)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
点击右上角即可分享
微信分享提示