Stats on Missing Facet


(Michael Sick) #1

For a faceted query, I'm returning data as a table showing the key_field,
counts, and min/max of the value_field. It's required to show the min/max
of the value field even for the group that has the facet key_field null. In
this case, facet.getMissingCount() isn't enough. Is there currently a way
to get the min/max (or other stats) for the missing case loaded as a facet?


(Shay Banon) #2

You can open an issue to support it, for now, you can simply index a value
that represents null.

On Tue, Nov 22, 2011 at 7:15 PM, Michael Sick <
michael.sick@serenesoftware.com> wrote:

For a faceted query, I'm returning data as a table showing the key_field,
counts, and min/max of the value_field. It's required to show the min/max
of the value field even for the group that has the facet key_field null. In
this case, facet.getMissingCount() isn't enough. Is there currently a way
to get the min/max (or other stats) for the missing case loaded as a facet?


(Michael Sick) #3

Opened at: https://github.com/elasticsearch/elasticsearch/issues/1491

On Wed, Nov 23, 2011 at 10:42 AM, Shay Banon kimchy@gmail.com wrote:

You can open an issue to support it, for now, you can simply index a value
that represents null.

On Tue, Nov 22, 2011 at 7:15 PM, Michael Sick <
michael.sick@serenesoftware.com> wrote:

For a faceted query, I'm returning data as a table showing the key_field,
counts, and min/max of the value_field. It's required to show the min/max
of the value field even for the group that has the facet key_field null. In
this case, facet.getMissingCount() isn't enough. Is there currently a way
to get the min/max (or other stats) for the missing case loaded as a facet?


(Michael Sick) #4

I tried reindexing using the null_value option:

aud_tran_typ_id: {
include_in_all: true
index: not_analyzed
store: yes
null_value: eas.missing
type: string
}

but the value does not end up in my facet counts. Should it or should I
have to add the default value in my code?

On Wed, Nov 23, 2011 at 11:23 AM, Michael Sick <
michael.sick@serenesoftware.com> wrote:

Opened at: https://github.com/elasticsearch/elasticsearch/issues/1491

On Wed, Nov 23, 2011 at 10:42 AM, Shay Banon kimchy@gmail.com wrote:

You can open an issue to support it, for now, you can simply index a
value that represents null.

On Tue, Nov 22, 2011 at 7:15 PM, Michael Sick <
michael.sick@serenesoftware.com> wrote:

For a faceted query, I'm returning data as a table showing the
key_field, counts, and min/max of the value_field. It's required to show
the min/max of the value field even for the group that has the facet
key_field null. In this case, facet.getMissingCount() isn't enough. Is
there currently a way to get the min/max (or other stats) for the missing
case loaded as a facet?


(Michael Sick) #5

Apologies, works fine. All trouble the result of overly fat fingers.

On Fri, Nov 25, 2011 at 11:11 AM, Michael Sick <
michael.sick@serenesoftware.com> wrote:

I tried reindexing using the null_value option:

aud_tran_typ_id: {
include_in_all: true
index: not_analyzed
store: yes
null_value: eas.missing
type: string
}

but the value does not end up in my facet counts. Should it or should I
have to add the default value in my code?

On Wed, Nov 23, 2011 at 11:23 AM, Michael Sick <
michael.sick@serenesoftware.com> wrote:

Opened at: https://github.com/elasticsearch/elasticsearch/issues/1491

On Wed, Nov 23, 2011 at 10:42 AM, Shay Banon kimchy@gmail.com wrote:

You can open an issue to support it, for now, you can simply index a
value that represents null.

On Tue, Nov 22, 2011 at 7:15 PM, Michael Sick <
michael.sick@serenesoftware.com> wrote:

For a faceted query, I'm returning data as a table showing the
key_field, counts, and min/max of the value_field. It's required to show
the min/max of the value field even for the group that has the facet
key_field null. In this case, facet.getMissingCount() isn't enough. Is
there currently a way to get the min/max (or other stats) for the missing
case loaded as a facet?


(system) #6