GET /work_order_olap/_search
{
"size": 0,
"aggs": {
"group_by_field": {
"terms": {
"size": 2,
"script": "doc['material_no'] +'####'+doc['material_name']+'####'+doc['material_category']"
}
,"aggs":{
"total_material_cost":{
"sum": {
"field": "total_material_cost"
}
}
}
}
}
}
方法2
GET /work_order_olap/_search
{
"size": 0,
"aggs": {
"group_by_field": {
"composite": {
"size": 1200,
"sources": [
{
"material_no": {
"terms": {
"field": "material_no"
}
}
}
, {
"material_name"