将这个Elasticsearch查询写成JAVA中调用Elasticsearch的查询代码：GET tmall_order_wide_2023-03-07/_search { "aggs": { "groupbyskuid": { "terms": { "field": "sku_id", "size": 50 }, "aggs": { "totalskuamount": { "sum": { "field": "total_amount" } } } } }, "size": 0 }

以下是将该Elasticsearch查询写成JAVA中调用Elasticsearch的查询代码的示例：

SearchRequest searchRequest = new SearchRequest("tmall_order_wide_2023-03-07");
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
TermsAggregationBuilder aggregationBuilder = AggregationBuilders.terms("groupbyskuid").field("sku_id").size(50);
SumAggregationBuilder sumAggregationBuilder = AggregationBuilders.sum("totalskuamount").field("total_amount");
aggregationBuilder.subAggregation(sumAggregationBuilder);
searchSourceBuilder.aggregation(aggregationBuilder);
searchSourceBuilder.size(0);
searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);