Grouping by keys that include nil values

Hello,

I'm looking to query an index for groups by a specific key. There are
documents that have nil values in in these queries, and by default ES
doesn't return these records in the aggregations key of the response.

I've tried applying a missing filter, and it looks like the hits key in
the response includes all the records, but the aggregations key does not.

What is a good strategy for this? Will I have to post process these
results? Index blank strings for nil values?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/907ce471-59a7-4832-bd42-e1bf3fc28833%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ideally, I'd like to see these records grouped under a nil key or something
automatically.


Mehul Kar
@mehulkar

On Wed, Feb 4, 2015 at 5:31 PM, Mehul Kar mehul.kar@gmail.com wrote:

Hello,

I'm looking to query an index for groups by a specific key. There are
documents that have nil values in in these queries, and by default ES
doesn't return these records in the aggregations key of the response.

I've tried applying a missing filter, and it looks like the hits key
in the response includes all the records, but the aggregations key does
not.

What is a good strategy for this? Will I have to post process these
results? Index blank strings for nil values?

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/wfMqQZGW2Ng/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/907ce471-59a7-4832-bd42-e1bf3fc28833%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/907ce471-59a7-4832-bd42-e1bf3fc28833%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAG7%3DhdizQ0198fLhs9EZSUUBwk6FrLM%3Dvg-LtQ2HnV_WLWirrg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

You would need to use a placeholder value. So if you know the value is NULL
or empty then insert the document with a string value of NIL or N/A or
something...

On Wednesday, 4 February 2015 20:41:18 UTC-5, Mehul Kar wrote:

Ideally, I'd like to see these records grouped under a nil key or
something automatically.


Mehul Kar
@mehulkar

On Wed, Feb 4, 2015 at 5:31 PM, Mehul Kar <mehu...@gmail.com <javascript:>

wrote:

Hello,

I'm looking to query an index for groups by a specific key. There are
documents that have nil values in in these queries, and by default ES
doesn't return these records in the aggregations key of the response.

I've tried applying a missing filter, and it looks like the hits key
in the response includes all the records, but the aggregations key does
not.

What is a good strategy for this? Will I have to post process these
results? Index blank strings for nil values?

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/wfMqQZGW2Ng/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/907ce471-59a7-4832-bd42-e1bf3fc28833%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/907ce471-59a7-4832-bd42-e1bf3fc28833%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/c63ce3c1-3c70-4716-90eb-78b973ff5290%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.