Aggregate Query in ElasticSearch / Lucene

Elastic Stack Elasticsearch
1

Hi,

I work in a company that uses Endeca for search and we are heavily relying
on aggregate queries (GROUP BY). Right now, is there an equivalent feature
in ES or Lucene?

Thanks
Raul

2

Have a look at the facet concept

HTH
David :wink:
@dadoonet

Le 27 janv. 2012 à 06:54, "Raul, Jr. Martinez" juneym@gmail.com a écrit :

Hi,

I work in a company that uses Endeca for search and we are heavily relying on aggregate queries (GROUP BY). Right now, is there an equivalent feature in ES or Lucene?

Thanks
Raul

3

what is the 'group by' exactly doing? in lucene there is a grouping
feature, in elasticsearch there is parent/child ...

Peter.

On Jan 27, 6:54 am, "Raul, Jr. Martinez" jun...@gmail.com wrote:

Hi,

I work in a company that uses Endeca for search and we are heavily relying
on aggregate queries (GROUP BY). Right now, is there an equivalent feature
in ES or Lucene?

Thanks
Raul

4

Hi,

ES and Lucene have a feature called "facets", it groups results according
to a field value, the count is also returned in the result, similar to a
aggregation "group by" SQL/DML function. For more details

On Mon, Jan 30, 2012 at 7:26 AM, Karussell tableyourtime@googlemail.comwrote:

what is the 'group by' exactly doing? in lucene there is a grouping
feature, in elasticsearch there is parent/child ...

Peter.

On Jan 27, 6:54 am, "Raul, Jr. Martinez" jun...@gmail.com wrote:

Hi,

I work in a company that uses Endeca for search and we are heavily
relying
on aggregate queries (GROUP BY). Right now, is there an equivalent
feature
in ES or Lucene?

Thanks
Raul

--
's
Shairon Toledo
http://www.google.com/profiles/shairon.toledo

5

Sorry for the late response.

The "Group By" feature collapses several records into a single record (a
representative record with complete fields).
I will investigate more on parent/child feature of Elasticsearch.

Thank you Peter.

@David, @Shairon:
Facets is an alternative solution but I would like to still get all the
fields of the representative record.

Thanks
Raul

On Monday, January 30, 2012 5:26:26 PM UTC+8, Karussell wrote:

what is the 'group by' exactly doing? in lucene there is a grouping
feature, in elasticsearch there is parent/child ...

Peter.

On Jan 27, 6:54 am, "Raul, Jr. Martinez" jun...@gmail.com wrote:

Hi,

I work in a company that uses Endeca for search and we are heavily
relying
on aggregate queries (GROUP BY). Right now, is there an equivalent
feature
in ES or Lucene?

Thanks
Raul

6

were you able t ok get the representative record and aggregation from Elasticsearch?

--
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.
For more options, visit https://groups.google.com/groups/opt_out.