How to get average, max, min etc. from a group of object


(Carmine Giangregorio) #1

Hi,
I'm using an elasticsearch db to store data for benchmarks.
I need to calculate and retrieve the average, max, min, etc. of a Group of
values.

I have something like:

Index = "myindex"
Type = "mytype"

Each object has 3 fields:

"load_time", "execution_time", "log_time".

I then run the benchmark and db is populated with hundreds of records. Now,
I would retrieve the average, the max and the min value for each field.
What query should I run?
I tried with statistical facet but I Always get a "unreognized token
exception"...

Thanks!

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/8f0b155c-34d9-45d8-a3e6-c41f3311720b%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Alexander Reelsen) #2

Hey,

can you provide some sample data, your mapping, the query and the concrete
error message, so others can reproduce/better spot your problem?
Statistical facet sounds good here, so the problem must be somewhere else...

--Alex

On Wed, Feb 5, 2014 at 8:05 PM, Carmine Giangregorio carminexx@gmail.comwrote:

Hi,
I'm using an elasticsearch db to store data for benchmarks.
I need to calculate and retrieve the average, max, min, etc. of a Group of
values.

I have something like:

Index = "myindex"
Type = "mytype"

Each object has 3 fields:

"load_time", "execution_time", "log_time".

I then run the benchmark and db is populated with hundreds of records.
Now, I would retrieve the average, the max and the min value for each field.
What query should I run?
I tried with statistical facet but I Always get a "unreognized token
exception"...

Thanks!

--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/8f0b155c-34d9-45d8-a3e6-c41f3311720b%40googlegroups.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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGCwEM-R1kuiihjbLWKQpp6s8XxxRCutCN%2BccsN5V2EZM%2BRsTg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3