I don't completely understand what you're trying to do - could you explain our use case in more detail?
The Missing Filter in Elasticsearch does the opposite of what you described - it returns documents that are missing a specific field.
In general, if you want to use a Missing Filter query DSL in Kibana, you should wrap the filter into a constant_score query. Instead of inserting this into the .kibana index directly, I'd recommend pasting the JSON directly the search bar in Discover and then saving that query using the UI (see screenshot) -- it's much less error prone. You can then examine the object and see its structure in Settings >> Objects, if you wish (see mine below).
Thanks Tanya! We've tried to do as you said, but the result is the same...
We want to get all the documents in one index with "coordenadasDestino" != NULL ... in all our documents this field exists but sometime its NULL or doens't have values
Thanks Tanya... it works but not as we expected... because in the spark code to inject to Elastic we put a "" into "coordenadasDestino instead putting [NULL]
We'll change the scala code in order to put NULL there. Thanks! Regads.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.