ElasticSearch 实战：ES中如何进行日期(数值)范围查询

在ElasticSearch中，可以使用range查询来查询特定日期范围内的数值或日期。以下是一个使用ElasticSearch的Java High Level REST Client进行日期范围查询的示例代码：

import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.index.query.RangeQueryBuilder;
import org.elasticsearch.search.builder.SearchSourceBuilder;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.search.SearchHit;
import java.io.IOException;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;
 
public class DateRangeQueryExample {
    public static void main(String[] args) throws IOException {
        try (RestHighLevelClient client = new RestHighLevelClient(...)) {
            // 索引名
            String indexName = "your_index";
            // 查询的字段名
            String fieldName = "your_date_field";
 
            // 设定日期范围
            ZonedDateTime startDateTime = ZonedDateTime.parse("2023-01-01T00:00:00Z");
            ZonedDateTime endDateTime = ZonedDateTime.parse("2023-01-31T23:59:59Z");
 
            // 创建查询构建器
            RangeQueryBuilder rangeQueryBuilder = QueryBuilders.rangeQuery(fieldName)
                    .gte(startDateTime.format(DateTimeFormatter.ISO_DATE_TIME), true)
                    .lte(endDateTime.format(DateTimeFormatter.ISO_DATE_TIME), true);
 
            // 构建搜索请求
            SearchRequest searchRequest = new SearchRequest(indexName);
            SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
            searchSourceBuilder.query(rangeQueryBuilder);
            searchRequest.source(searchSourceBuilder);
 
            // 执行搜索
            SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
 
            // 处理搜索结果
            for (SearchHit hit : searchResponse.getHits().getHits()) {
                System.out.println(hit.getSourceAsString());
            }
        }
    }
}

在这个例子中，我们使用了RangeQueryBuilder来构建一个日期范围查询。gte方法表示“大于等于”，lte方法表示“小于等于”。这里的日期格式化为ISO_DATE_TIME，你可以根据实际存储的日期格式进行调整。记得替换your_index和\`your\_dat