ES设置字段类型

1：为索引设置字段类型

PUT /ad_mmp_cdr_fee_20200819_8601
{
  "mappings": {
    "properties": {
      "currentChargeAmount":{"type": "float"},
      "sumChargeAmount":{"type": "float"}
    }
  },
  "settings": {
    "index":{
      "number_of_shards":1,
      "number_of_replicas":0
    }
  }
}

2：查询
GET /ad_mmp_cdr_fee_/mapping
3：删除索引
DELETE ad_mmp_cdr_fee
4：向索引中添加数据

POST /ad_mmp_cdr_fee_20200819_8601/_doc
{
  "cdrId" :"113000000000000194",
  "timeStamp":"20200810010136",
  "tenantId" :"8601",
  "resultCode":"0",
  "advertisersId":"15362227628412928",
  "campaignId":"23805785543165",
  "flightId":"33805785543165",
  "placementId":"13805785542971",
  "rateType":"CPD",
  "currentDeliverQuantity":"1",
  "sumDeliverQuantity":"3",
  "sumChargedQuantity":"3",
  "currentChargeAmount":"400000.000000",
  "sumChargeAmount":"1200000.000000",
  "startDate":"20200807000000",
  "endDate":"20200812000000",
  "budgetAmount":"400000",
  "budgetLimitFlag":"0",
  "deliverAmount":"-1",
  "deliverLimitFlag":"0",
  "extendInfo":""
}

5：使用聚组函数查询

GET ad_mmp_cdr_fee_*/_search
{
	"aggregations": {
		"groupby": {
			"composite": {
				"size": 1000,
				"sources": [{
					"flightId": {
						"terms": {
							"field": "flightId.keyword",
							"missing_bucket": true,
							"order": "asc"
						}
					}
				}]
			},
			"aggregations": {
				"sumActualRate": {
					"sum": {
						"field": "sumChargeAmount"
					}
				}
			}
		}
	}
}