Multi-level facet

Raul_Jr_Martinez · June 21, 2011, 5:47am

Hi,

I'm mostly working with Endeca related projects and I see
ElasticSearch as an interesting open source project especially when
dealing with massive data -- through auto-autosharding.

Endeca provides multi-level dimension/refinements. Is there a way to
do the same in ElasticSearch? One major use of this feature is with
multi-level categories.

Thanks in advance!

Raul

ppearcy · June 21, 2011, 6:31am

Hey Raul,
Last I saw, not supported:
http://groups.google.com/a/elasticsearch.com/group/users/browse_thread/thread/fb0a38ca19b02bde/b35d9531047278b6?lnk=gst&q=facet+hierarchical#b35d9531047278b6

However, knowing Shay, it'll be there any day

Thanks,
Paul

On Jun 20, 11:47 pm, rmartinez jun...@gmail.com wrote:

Hi,

I'm mostly working with Endeca related projects and I see
Elasticsearch as an interesting open source project especially when
dealing with massive data -- through auto-autosharding.

Endeca provides multi-level dimension/refinements. Is there a way to
do the same in Elasticsearch? One major use of this feature is with
multi-level categories.

Thanks in advance!

Raul

Raul_Jr_Martinez · June 21, 2011, 8:49am

Paul,

Thanks. Looking forward to this feature!

Thanks,
Raul

On Jun 21, 2:31 pm, Paul ppea...@gmail.com wrote:

Hey Raul,
Last I saw, not supported:http://groups.google.com/a/elasticsearch.com/group/users/browse_threa...

However, knowing Shay, it'll be there any day

Thanks,
Paul

On Jun 20, 11:47 pm, rmartinez jun...@gmail.com wrote:

Hi,

I'm mostly working with Endeca related projects and I see
Elasticsearch as an interesting open source project especially when
dealing with massive data -- through auto-autosharding.

Endeca provides multi-level dimension/refinements. Is there a way to
do the same in Elasticsearch? One major use of this feature is with
multi-level categories.

Thanks in advance!

Raul

otisg · June 21, 2011, 8:55pm

And if you want to port things from Solr before Shay gets to it, have
a look at the Pivot stuff in Solr: http://search-lucene.com/?q=pivot

Otis

On Jun 21, 2:31 am, Paul ppea...@gmail.com wrote:

Hey Raul,
Last I saw, not supported:http://groups.google.com/a/elasticsearch.com/group/users/browse_threa...

However, knowing Shay, it'll be there any day

Thanks,
Paul

On Jun 20, 11:47 pm, rmartinez jun...@gmail.com wrote:

Hi,

I'm mostly working with Endeca related projects and I see
Elasticsearch as an interesting open source project especially when
dealing with massive data -- through auto-autosharding.

Endeca provides multi-level dimension/refinements. Is there a way to
do the same in Elasticsearch? One major use of this feature is with
multi-level categories.

Thanks in advance!

Raul

otisg · June 29, 2011, 9:01pm

Btw. I just created "Support Hierarchical Facets" at
https://github.com/elasticsearch/elasticsearch/issues/1076 .

I was going to suggest to vote for it if you are interested in having
that, but I don't see a way to vote on issues on Github...

Otis

On Jun 21, 4:55 pm, Otis otis.gospodne...@gmail.com wrote:

And if you want to port things from Solr before Shay gets to it, have
a look at thePivotstuff in Solr:http://search-lucene.com/?q=pivot

Otis

On Jun 21, 2:31 am, Paul ppea...@gmail.com wrote:

Hey Raul,
Last I saw, not supported:http://groups.google.com/a/elasticsearch.com/group/users/browse_threa...

However, knowing Shay, it'll be there any day

Thanks,
Paul

On Jun 20, 11:47 pm, rmartinez jun...@gmail.com wrote:

Hi,

I'm mostly working with Endeca related projects and I see
Elasticsearch as an interesting open source project especially when
dealing with massive data -- through auto-autosharding.

Endeca provides multi-level dimension/refinements. Is there a way to
do the same in Elasticsearch? One major use of this feature is with
multi-level categories.

Thanks in advance!

Raul

Hari_Shankar · June 30, 2011, 4:43am

Great! This feature would be awesome..

On Thu, Jun 30, 2011 at 2:31 AM, Otis otis.gospodnetic@gmail.com wrote:

Btw. I just created "Support Hierarchical Facets" at
https://github.com/elasticsearch/elasticsearch/issues/1076 .

I was going to suggest to vote for it if you are interested in having
that, but I don't see a way to vote on issues on Github...

Otis

On Jun 21, 4:55 pm, Otis otis.gospodne...@gmail.com wrote:

And if you want to port things from Solr before Shay gets to it, have
a look at thePivotstuff in Solr:http://search-lucene.com/?q=pivot

Otis

On Jun 21, 2:31 am, Paul ppea...@gmail.com wrote:

Hey Raul,
Last I saw, not supported:
http://groups.google.com/a/elasticsearch.com/group/users/browse_threa...

However, knowing Shay, it'll be there any day

Thanks,
Paul

On Jun 20, 11:47 pm, rmartinez jun...@gmail.com wrote:

Hi,

I'm mostly working with Endeca related projects and I see
Elasticsearch as an interesting open source project especially when
dealing with massive data -- through auto-autosharding.

Endeca provides multi-level dimension/refinements. Is there a way to
do the same in Elasticsearch? One major use of this feature is with
multi-level categories.

Thanks in advance!

Raul

Raul_Jr_Martinez · July 19, 2011, 9:59am

Otis,
Looks interesting. Is this code part of the recent release already?

github.com/elastic/elasticsearch

Nested Objects Facets Support

opened 01:20AM - 07 Jul 11 UTC

closed 01:21AM - 07 Jul 11 UTC

kimchy

>feature v0.17.0

Support faceting on nested documents. It includes both faceting on child documen…ts matching a specific nested query (using scopes), and faceting on all nested documents of the matching root documents. Why is it good for? First of all, this is the only way to use facets on nested documents once they are used (possibly for other reasons). But, there is also facet specific reason why nested documents can be used, and thats the fact that facets working on different key and value field (like `term_stats`, or `histogram`) can now support cases where both are multi valued properly. The following will use this same mapping: ``` { "type1" : { "properties" : { "obj1" : { "type" : "nested" } } } } ``` And, here is a sample data: ``` { "obj1" : [ { "name" : "blue", "count" : 4 }, { "name" : "green", "count" : 6 } ] } ``` ## Nested Query Facets Any `nested` query allows to specify a `_scope` associated with it. Any `facet` allows for a scope to be defined on it controlling the scope it will execute against. For example, the following `facet1` terms stats facet will only run on documents matching the nested query associated with `my_scope`. ``` { "query" : { "nested" : { "_scope" : "my_scope" "path" : "obj1", "score_mode" : "avg" "query" : { "bool" : { "must" : [ "text" : {"obj1.name" : "blue"}, "range" : {"obj1.count" : {"gt" : 5}} ] } } } }, "facets" : { "facet1" : { "terms_stats" : { "key_field" : "obj1.name", "value_field" : "obj1.count", }, "scope" : "my_scope" } } } ``` ## All Nested Matching Root Documents Another option is to run the facet on all the nested documents matching the root objects that the main query will end up producing. For example: ``` { "query" : { "match_all" : {} }, "facets" : { "facet1" : { "terms_stats" : { "key_field" : "name", "value_field" : "count", }, "nested" : "obj1" } } } ``` The `nested` element provides the path to the nested document (can be a multi level nested docs) that will be used.

Looking forward on how to use it via Query DSL.

Regards,

Raul

On Jun 30, 5:01 am, Otis otis.gospodne...@gmail.com wrote:

Btw. I just created "Support Hierarchical Facets" athttps://github.com/elasticsearch/elasticsearch/issues/1076.

I was going to suggest to vote for it if you are interested in having
that, but I don't see a way to vote on issues on Github...

Otis

On Jun 21, 4:55 pm, Otis otis.gospodne...@gmail.com wrote:

And if you want to port things from Solr before Shay gets to it, have
a look at thePivotstuff in Solr:http://search-lucene.com/?q=pivot

Otis

On Jun 21, 2:31 am, Paul ppea...@gmail.com wrote:

Hey Raul,
Last I saw, not supported:http://groups.google.com/a/elasticsearch.com/group/users/browse_threa...

However, knowing Shay, it'll be there any day

Thanks,
Paul

On Jun 20, 11:47 pm, rmartinez jun...@gmail.com wrote:

Hi,

I'm mostly working with Endeca related projects and I see
Elasticsearch as an interesting open source project especially when
dealing with massive data -- through auto-autosharding.

Endeca providesmulti-leveldimension/refinements. Is there a way to
do the same in Elasticsearch? One major use of this feature is with
multi-levelcategories.

Thanks in advance!

Raul

phobos182 · July 25, 2011, 1:07pm

This would be a huge gain for us. +1