Elasticsearch find items with empty field

Question

I am trying to get items from my index with empty email.

If i search for items with email:"" i get 0 results

"query": {
    "term": {
      "email": ""
    }
  }

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 0,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  }
}

if i make a query like:

{
  "query": {
    "term": {
      "id": "1234"
    }
  }
}

i get an item with email:""

"_source" : {
          "id" : "1234",
          "email" : "",
        }

My mappings look like so:

{
  "mappings": {
    "_doc": {
      "dynamic": "false",
      "properties": {
        "email": {
          "type": "text",
          "analyzer": "email_analyzer"
        },
        "id": {
          "type": "keyword"
        }
      }
    }
  }
}

What can be the cause for this ?

you should not be using term query for text fields .. elastic.co/guide/en/elasticsearch/reference/current/…. Also this SO thread has an answer for searching for empty text stackoverflow.com/questions/25561981/… — subram
– subram, Commented Feb 14, 2024 at 13:46

rabbitbr · Accepted Answer · 2024-02-15 00:21:36Z

0

you need use exist query.

{
  "query": {
    "exists": {
      "field": "email"
    }
  }
}

answered Feb 15, 2024 at 0:21

rabbitbr

3,2812 gold badges8 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike R · Accepted Answer · 2024-02-18 08:15:36Z

0

You can try using this with .keyword like the following

"query": {
"term": {
  "email.keyword": ""
  }
 }

edited Feb 18, 2024 at 8:15

Mike R

5828 silver badges25 bronze badges

answered Feb 15, 2024 at 17:08

Vijaya Babu

114 bronze badges

Collectives™ on Stack Overflow

Elasticsearch find items with empty field

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related