MySQL "not in" Query in Elasticsearch

Question

I want to achieve something like this SELECT * FROM myindex where _id not in (1, 2, 3) in Elasticsearch. One way to do this is:

{
    "from": 0,
    "size": 200,
    "query": {
        "bool": {
            "must": {
                "bool": {
                    "must_not": {
                        "bool": {
                            "should": [
                                {
                                    "match": {
                                        "_id": {
                                            "query": 1,
                                            "type": "phrase"
                                        }
                                    }
                                },
                                {
                                    "match": {
                                        "_id": {
                                            "query": 2,
                                            "type": "phrase"
                                        }
                                    }
                                },
                                {
                                    "match": {
                                        "_id": {
                                            "query": 3,
                                            "type": "phrase"
                                        }
                                    }
                                }
                            ]
                        }
                    }
                }
            }
        }
    }
}

But this approach wouldn't scale for a big array because this will be a huge query. Is there a better way to do this?

Answer 1

Maybe something like this?

GET _search
{
  "query" : {
    "bool" : {
      "must_not" : {
        "terms" : {
          "_id" : [1,2,3]
        }
      }
    }
  }
}