Aggregate Query in ElasticSearch / Lucene

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

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

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

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
http://www.elasticsearch.org/guide/reference/api/search/facets/

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

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

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.