如题 需要条件查询某个区间每天的平均值,按照日期分组 :SQL: select date,avg(temp) from table where date>=to_date('20120215','yyyy-MM-dd') and date<=to_date('20121230','yyyy-MM-dd) group by date
//过滤时间 if (map.get("startTime") != null && map.get("endTime") != null) { RangeQueryBuilder rangequerybuilder = QueryBuilders .rangeQuery("LASTUPDATETIME").from(map.get("startTime").toString()).to(map.get("endTime").toString());//.format("yyyy-MMdd HH:ss:mm") queryBuilder.must(rangequerybuilder); } else if (map.get("endTime") != null) { RangeQueryBuilder rangequerybuilder = QueryBuilders .rangeQuery("LASTUPDATETIME").to(map.get("endTime").toString());//.format("yyyy-MM-dd HH:ss:mm") queryBuilder.must(rangequerybuilder); } else if (map.get("startTime") != null) { RangeQueryBuilder rangequerybuilder = QueryBuilders .rangeQuery("LASTUPDATETIME").from(map.get("startTime").toString());//.format("yyyy-MM-dd HH:ss:mm") queryBuilder.must(rangequerybuilder); }
if (map.get("tem") != null) { //B teamAgg1 = AggregationBuilders.avg("TEM_AS").field("TEM"); teamAgg2=AggregationBuilders.dateHistogram("lastupdatetime_Agg").field("LAST