Best Way To Check If A Field Exist In An Elasticsearch Document


Answer :

You can use the exists filter combined with a bool/must filter like this:

{   "query": {     "filtered": {       "filter": {         "bool": {           "must": [             {               "exists": {                 "field": "price"               }             },             ...     <-- your other constraints, if any           ]         }       }     }   } } 

DEPRECATED (since ES5) You can also use the missing filter combined with a bool/must_not filter:

{   "query": {     "filtered": {       "filter": {         "bool": {           "must_not": [             {               "missing": {                 "field": "price"               }             }           ]         }       }     }   } } 

The exists filter has been replaced by exists query from ES 2.1, though the working of it is the same. Also, the missing filter is removed and missing query deprecated.

To get all docs which have a particular field,

"bool": {     "must": {         "exists": {             "field": "my_field"         }     } } 

and to get all docs which does NOT have a particular field, use it with must_not like this

"bool": {     "must_not": {         "exists": {             "field": "my_field"         }     } } 

Elastic docs: https://www.elastic.co/guide/en/elasticsearch/reference/2.3/query-dsl-missing-query.html


You can directly do

{     "query": {         "exists": {             "field": "fieldName"         }     } } 

If you wanna add some match too, then you can go for

{     "query": {         "bool": {             "must": [{                 "match": {                     "fieldName": "value"                 }             },             {                 "exists": {                     "field": "fieldName"                 }             }]         }     } } 

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-exists-query.html


Comments

Popular posts from this blog

Are Regular VACUUM ANALYZE Still Recommended Under 9.1?

Can Feynman Diagrams Be Used To Represent Any Perturbation Theory?