CODEWITHSUNDEEP
elasticsearch
Darby
Darby

Reputation: 789

elasticsearch filters aggregation won't work

Like this post, I can't get filters agg to work:

GET files/_search
{
  "query": {
    "match": {
      "words": "sugar"
    }
  },
  "aggs": {
    "xxx": {
      "filters": {
        "filter_list": {
          "errors": {
            "term": {
              "abstract": "error"
            }
          },
          "warnings": {
            "term": {
              "abstract": "warning"
            }
          }
        }
      },
      "aggs": {
        "st": {
          "significant_terms": {
            "field": "abstract"
          }
        }
      }
    }
  }
}

SearchParseException[[files][3]: query[words:sugar],from[-1],size[-1]: Parse Failure [Unknown key for a START_OBJECT in [xxx]: [filter_list].]]; }{[tIS8uY8nTDil6kWtgsbkQg][files][4]: SearchParseException[[files][4]: query[words:sugar],from[-1],size[-1]: Parse Failure [Failed to parse source [{\n \"query\": {\n
\"match\": {\n \"words\": \"sugar\"\n }\n },\n \"aggs\": {\n \"xxx\": {\n \"filters\": {\n \"filter_list\": {\n
\"errors\": {\n \"term\": {\n \"abstract\": \"error\"\n }\n },\n \"warnings\": {\n
\"term\": {\n \"abstract\": \"warning\"\n }\n }\n }\n },\n \"aggs\": {\n \"st\": {\n
\"significant_terms\": {\n \"field\": \"abstract\"\n
}\n }\n }\n }\n }\n}\n]]]; nested: SearchParseException[[epars][4]: query[words:sugar],from[-1],size[-1]: Parse Failure [Unknown key for a START_OBJECT in [xxx]: [filter_list].]]; }]", "status": 400 }

Upvotes: 0

Views: 5600

Answers (1)

Val
Val

Reputation: 217254

You have only one thing wrong, i.e. filter_list should read filters, as it is a mandatory element of the filters aggregation.

GET files/_search
{
  "query": {
    "match": {
      "words": "sugar"
    }
  },
  "aggs": {
    "xxx": {
      "filters": {
        "filters": {           <---- change this
          "errors": {
            "term": {
              "abstract": "error"
            }
          },
          "warnings": {
            "term": {
              "abstract": "warning"
            }
          }
        }
      },
      "aggs": {
        "st": {
          "significant_terms": {
            "field": "abstract"
          }
        }
      }
    }
  }
}

Upvotes: 1

Related Questions