畸形的查询，预期的end_object，但在Kibana(弹性搜索)中发现了field_name错误

Question

我正在运行以下查询，因为我在响应窗口中遇到错误，如下所示：

//错误

[match] malformed query, expected [END_OBJECT] but found [FIELD_NAME]

任何人都可以建议为什么我不能在"应该"部分中使用多个匹配块？

//响应 - 如果我拿出一个匹配块，则它有效？

{
  "error": {
   "root_cause": [
     {
       "type": "parsing_exception",
       "reason": "[match] malformed query, expected [END_OBJECT] but found [FIELD_NAME]",
        "line": 9,
        "col": 13
     }
   ],
    "type": "parsing_exception",
    "reason": "[match] malformed query, expected [END_OBJECT] but found [FIELD_NAME]",
    "line": 9,
    "col": 13
   },
   "status": 400
}

//我的查询

GET _search
  {
    "query": {
      "bool": {
        "should": [
        {
           "match": {
           "text": "facebook advice"
        },
           "match": {
           "profile": "facebook advice"
        }
      }
    ],
    "minimum_number_should_match": 1,
    "filter": {
      "term": {
        "accountid": "22"
      }
    }
  }
}

Answer 1

您的查询已畸形。这样写的是：

GET _search
{
  "query": {
    "bool": {
      "should": [
        {
          "match": {
            "text": "facebook advice"
          }
        },
        {
          "match": {
            "profile": "facebook advice"
          }
        }
      ],
      "minimum_number_should_match": 1,
      "filter": {
        "term": {
          "accountid": "22"
        }
      }
    }
  }
}

Answer 2

尝试以下查询。它对我有用。

-------- working console query -------------
POST /usage-metering-stats/_search?size=10
{
  "query": {
    "bool": {
      "must": [{
                    "term": {
                        "tenantId": "2222"
                    }
                },
                {
                    "term": {
                        "instanceId": "1212"
                    }
                },
                {
                    "term": {
                        "cspId": "25680"
                    }
                },
                {
                    "term": {
                        "api": "2"
                    }
                }
            ]
      }
  },
  "aggs": {
    "totalCount": { "sum": { "field": "count" } }
  }
}