分桶聚合问题请教

[LLeiFeng]

select  * from stanlee_decision-engine-pre_2019-09-25  group by processCode, filter('filter',isDefaultProcessRouteValue=TERM(false)),filter('second',isDefaultFeatureValue=TERM(false)) order by timeStamp desc limit 100

以上sql返回的值格式为：

{
  "key": "td_duotou_model_bb",
  "doc_count": 40790,
  "filter@FILTER": {
    "doc_count": 11,
    "second@FILTER": {
      "doc_count": 11
    }
  }
}

请问想把second这层filter提出来,两个filter不影响,sql应该怎么写呢 即返回的格式如下：

{
  "key": "td_duotou_model_bb",
  "doc_count": 40790,
  "filter@FILTER": {
    "doc_count": 11
  },
  "second@FILTER": {
    "doc_count": 11
  }
}

谢谢！

[LLeiFeng]

@shi-yuan 大神求解~

[shi-yuan]

这个得考虑支持Filters Aggregation

[shi-yuan]

select  * from stanlee_decision-engine-pre_2019-09-25  
group by processCode, 
filters(filter('filter',isDefaultProcessRouteValue=TERM(false)),filter('second',isDefaultFeatureValue=TERM(false))) 
order by timeStamp desc 
limit 100

{
  "from": 0,
  "size": 0,
  "sort": [
    {
      "timeStamp": {
        "order": "desc"
      }
    }
  ],
  "aggregations": {
    "processCode": {
      "terms": {
        "field": "processCode",
        "size": 100,
        "shard_size": 5000,
        "min_doc_count": 1,
        "shard_min_doc_count": 0,
        "show_term_doc_count_error": false,
        "order": [
          {
            "_count": "desc"
          },
          {
            "_key": "asc"
          }
        ]
      },
      "aggregations": {
        "filters@FILTERS": {
          "filters": {
            "filters": {
              "filter@FILTER": {
                "bool": {
                  "must": [
                    {
                      "term": {
                        "isDefaultProcessRouteValue": {
                          "value": false,
                          "boost": 1
                        }
                      }
                    }
                  ],
                  "adjust_pure_negative": true,
                  "boost": 1
                }
              },
              "second@FILTER": {
                "bool": {
                  "must": [
                    {
                      "term": {
                        "isDefaultFeatureValue": {
                          "value": false,
                          "boost": 1
                        }
                      }
                    }
                  ],
                  "adjust_pure_negative": true,
                  "boost": 1
                }
              }
            },
            "other_bucket": false,
            "other_bucket_key": "_other_"
          }
        }
      }
    }
  }
}