Elasticsearch group

I have been trying to find a way to get something like group by where it
only returns documents that have a selective feild that is uniqie, and then
be able to do something simular to a mysql min max sum or something of the
sorts. Lets say i was building a database of dogs on houses on each street
i may want to pull which houses have dogs, insteed of having a look up type
or index i want to search all the dogs and then only reply once per
address. what would also be useful is if it was able to return the number
of dogs per house using a simular query.

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

Sounds like you are looking for facets. The terms facet and the terms stats
facet should solve most of your use cases.

http://www.elasticsearch.org/guide/reference/api/search/facets/terms-facet/
http://www.elasticsearch.org/guide/reference/api/search/facets/terms-stats-facet/

--
Ivan

On Fri, Apr 5, 2013 at 4:54 PM, Wojons Tech wojonstech@gmail.com wrote:

I have been trying to find a way to get something like group by where it
only returns documents that have a selective feild that is uniqie, and then
be able to do something simular to a mysql min max sum or something of the
sorts. Lets say i was building a database of dogs on houses on each street
i may want to pull which houses have dogs, insteed of having a look up type
or index i want to search all the dogs and then only reply once per
address. what would also be useful is if it was able to return the number
of dogs per house using a simular query.

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

I have come across these before but i am having a hard time understanding
how to use them.

On Fri, Apr 5, 2013 at 5:07 PM, Ivan Brusic ivan@brusic.com wrote:

Sounds like you are looking for facets. The terms facet and the terms
stats facet should solve most of your use cases.

http://www.elasticsearch.org/guide/reference/api/search/facets/terms-facet/

http://www.elasticsearch.org/guide/reference/api/search/facets/terms-stats-facet/

--
Ivan

On Fri, Apr 5, 2013 at 4:54 PM, Wojons Tech wojonstech@gmail.com wrote:

I have been trying to find a way to get something like group by where it
only returns documents that have a selective feild that is uniqie, and then
be able to do something simular to a mysql min max sum or something of the
sorts. Lets say i was building a database of dogs on houses on each street
i may want to pull which houses have dogs, insteed of having a look up type
or index i want to search all the dogs and then only reply once per
address. what would also be useful is if it was able to return the number
of dogs per house using a simular query.

--
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 a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/p8enWi6XqXI/unsubscribe?hl=en-US
.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Enjoy,
Alexis Okuwa
WojonsTech
424.835.1223

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

Post a few sample documents and someone can help you craft a query.

http://www.elasticsearch.org/help/

--
Ivan

On Fri, Apr 5, 2013 at 5:34 PM, Wojons Tech wojonstech@gmail.com wrote:

I have come across these before but i am having a hard time understanding
how to use them.

On Fri, Apr 5, 2013 at 5:07 PM, Ivan Brusic ivan@brusic.com wrote:

Sounds like you are looking for facets. The terms facet and the terms
stats facet should solve most of your use cases.

http://www.elasticsearch.org/guide/reference/api/search/facets/terms-facet/

http://www.elasticsearch.org/guide/reference/api/search/facets/terms-stats-facet/

--
Ivan

On Fri, Apr 5, 2013 at 4:54 PM, Wojons Tech wojonstech@gmail.com wrote:

I have been trying to find a way to get something like group by where it
only returns documents that have a selective feild that is uniqie, and then
be able to do something simular to a mysql min max sum or something of the
sorts. Lets say i was building a database of dogs on houses on each street
i may want to pull which houses have dogs, insteed of having a look up type
or index i want to search all the dogs and then only reply once per
address. what would also be useful is if it was able to return the number
of dogs per house using a simular query.

--
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 a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/p8enWi6XqXI/unsubscribe?hl=en-US
.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Enjoy,
Alexis Okuwa
WojonsTech
424.835.1223

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