ES联合查询

联合查询：

sql:

POST _plugins/_sql?format=json
{
  "query": "SELECT md5_id,authors from mix_data_2 where Match_Query(`authors`,'%Multiple,Multiple%') and authors.keyword <> 'Multiple'"
}

dsl:

GET /mix_data_2/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "wildcard": {
            "authors.keyword": "*MUltiple*"
          }
        }
      ],
      "must_not": [
        {
          "term": {
            "authors.keyword": "Multiple"
          }
        }
      ]
    }
  }
}

注意：本文归作者所有，未经作者允许，不得转载