12.1 查询 DSL 语句

交易总额

GET gmall_order/_search
{
  "query": {
    "bool": {
      "filter": {
        "term": {
          "createDate": "2019-05-17"
        }
      }
    }
  }
  , "aggs": {
    "sum_totalAmount": {
      "sum": {
        "field": "totalAmount"
      }

    }
  }
}

交易额小时明细

GET gmall_order/_search
{
  "query": {
    "bool": {
      "filter": {
        "term": {
          "createDate": "2019-05-17"
        }
      }
    }
  }
  , "aggs": {
    "groupby_createHour": {
      "terms": {
        "field": "createHour",
        "size": 24
      }
      , "aggs": {
        "sum_totalAmount": {
          "sum": {
            "field": "totalAmount"
          }
        }
      }
    }

  }
}