使用 Java 以 csv 格式提取弹性搜索查询输出

Question

我用java查询弹性搜索我想把我的查询数据导出到csv文件我为此感到头疼。。。。请任何人能帮我处理这段代码吗？。。下面是我的java查询代码

       try {
        RangeQueryBuilder rangeQ = QueryBuilders
                .rangeQuery("@timestamp")
                .gte("1663632000000")
                .lte("1663804799000")
                .format("epoch_millis");

        TermsAggregationBuilder termsAggregation = AggregationBuilders
                .terms("term_by_client_id")
                .field("labels.client_id")
                .size(100000)
                .minDocCount(1);

        termsAggregation
                .subAggregation(
                        AggregationBuilders
                                .sum("sum_by")
                                .field("labels.row_count")
                );
        termsAggregation
                .subAggregation(
                        AggregationBuilders
                                .terms("term_By_job")
                                .field("labels.job_id")
                );


        SearchRequest searchRequest = new SearchRequest();
        searchRequest.indices("*itm*");


        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.query(rangeQ);
        searchSourceBuilder.aggregation(termsAggregation);
       // searchSourceBuilder.size(100000);
        searchRequest.source(searchSourceBuilder);

        SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println(searchResponse);

        Aggregations aggregations = searchResponse.getAggregations();
        Map<String, Aggregation> aggregationMap = aggregations.asMap();
        for (Map.Entry<String, Aggregation> each : aggregationMap.entrySet()){
            System.out.println((each.getValue()));
        }

    } catch (IOException e) {
        throw new RuntimeException(e);
    }
}

查询的输出是这样的

"桶":[{"key":"1741433 "，" doc_count":1}，{"key":"1741435 "，" doc_count":1}，{"key":"1741436 "，" doc_count":1}，{"key":"1741440 "，" doc_count":1}，{"key":"1741441 "，" doc_count":1}，{"key":"1741442 "，" doc_count "

请在这里帮我处理这个代码，我将不胜感激。谢谢。

Answer 1

这不完全是你想要的，但我想这可能对你有帮助，所以我建议你这么做。

您可以像这样使用这个轻量级工具

# Backup the results of a query to a file
elasticdump \
  --input=http://production.es.com:9200/my_index \
  --output=query.json \
  --searchBody="{\"query\":{\"term\":{\"username\": \"admin\"}}}"

然后使用Java lib或任何适合您的在线工具将json转换成csv。