es 学习笔记

order_detail_20190601/order_detail/_search
es 查询
{
  "query": {
    "bool": {
      "must": [
        { "term": { "deptId1": "2493" } },
        { "term": { "split": "" } }
      ]
    }
  },
  "aggs" : {
        "intraday_return" : { "sum" : { "field" : "index1" } }
    }
}

等于sql：

SELECT sum(index1) FROM table WHERE split=‘‘ AND deptId1=‘2493‘;


{
  "query": {
    "bool": {
      "must": [
        { "term": { "deptId1": "2493" } },
        { "term": { "split": "" } },
        { "term": { "payed": "false" } }
      ],
      "filter": {
        "range": {
          "index1": {
            "gte": 100000
          }
        }
      }
      
    }
  },
  "aggs" : {
        "intraday_return" : { "sum" : { "field" : "index1" } }
    }
}


select sum(index1) from table where deptId1=‘2493‘ and split=‘‘ and payed=‘false‘ and index1>=100000