Group by clause

Elastic Stack Elasticsearch
1

Hi All,

I would like to know about the support of group by clause in Elasticsearch.

Below is the sample query that we are currently firing in MySQL.

select column_name, aggregate_function(column_name)
from table
where column_name operator value
Group by column_name

Please share ways to achieve the support of above query in elasticsearch.

Thanks,
Ankit

--
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.

2

Ankit,

Check out the Facet API -
Elasticsearch Platform — Find real-time answers at scale | Elastic See the
various types of facets down the right side of the page. Good luck!

--Mike

On Thu, Jun 6, 2013 at 9:23 AM, Ankit Jain ankitjaincs06@gmail.com wrote:

Hi All,

I would like to know about the support of group by clause in Elasticsearch.

Below is the sample query that we are currently firing in MySQL.

select column_name, aggregate_function(column_name)
from table
where column_name operator value
Group by column_name

Please share ways to achieve the support of above query in elasticsearch.

Thanks,
Ankit

--
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.

--
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.