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 @ 2024-05-23 16:19  leepandar  阅读(31)  评论(0编辑  收藏  举报