Hi!
I am using elasticsearch to store a serial values of a metric like
{timestamp, value}. Now, I am trying to calculate the average of this
metric of each minute in some time range. I did this by a filter to get all
docs in that minute and calculate the avg and then the next minute. So I
have to do a searching for every minute and the performance was terrible.
Is there any sugestion for a better algorithm for better performance? Thank
you for any comment!

Hi!
I am using elasticsearch to store a serial values of a metric like
{timestamp, value}. Now, I am trying to calculate the average of this
metric of each minute in some time range. I did this by a filter to get all
docs in that minute and calculate the avg and then the next minute. So I
have to do a searching for every minute and the performance was terrible.
Is there any sugestion for a better algorithm for better performance? Thank
you for any comment!

It's funny, I tried to help you and currently have the same problem
Does anyone know how to get date histogram with average field value within
each date entry ? Standard date histogram allows to get count only but I do
not know how to get sum, avg, etc... If I have at least sum I could get avg
by myself.

Hi!
I am using elasticsearch to store a serial values of a metric like
{timestamp, value}. Now, I am trying to calculate the average of this
metric of each minute in some time range. I did this by a filter to get all
docs in that minute and calculate the avg and then the next minute. So I
have to do a searching for every minute and the performance was terrible.
Is there any sugestion for a better algorithm for better performance? Thank
you for any comment!

I found the answer, Alan, you have to use Date Histogram with key_field
pointing to timestamp and value_field pointing value. Then you will get
mean (average) of value within the timestamp entry.

It's funny, I tried to help you and currently have the same problem
Does anyone know how to get date histogram with average field value within
each date entry ? Standard date histogram allows to get count only but I do
not know how to get sum, avg, etc... If I have at least sum I could get avg
by myself.

Hi!
I am using elasticsearch to store a serial values of a metric like
{timestamp, value}. Now, I am trying to calculate the average of this
metric of each minute in some time range. I did this by a filter to get all
docs in that minute and calculate the avg and then the next minute. So I
have to do a searching for every minute and the performance was terrible.
Is there any sugestion for a better algorithm for better performance? Thank
you for any comment!

I found the answer, Alan, you have to use Date Histogram with key_field
pointing to timestamp and value_field pointing value. Then you will get
mean (average) of value within the timestamp entry.

It's funny, I tried to help you and currently have the same problem
Does anyone know how to get date histogram with average field value
within each date entry ? Standard date histogram allows to get count only
but I do not know how to get sum, avg, etc... If I have at least sum I
could get avg by myself.

Hi!
I am using elasticsearch to store a serial values of a metric like
{timestamp, value}. Now, I am trying to calculate the average of this
metric of each minute in some time range. I did this by a filter to get all
docs in that minute and calculate the avg and then the next minute. So I
have to do a searching for every minute and the performance was terrible.
Is there any sugestion for a better algorithm for better performance? Thank
you for any comment!

I found the answer, Alan, you have to use Date Histogram with key_field
pointing to timestamp and value_field pointing value. Then you will get
mean (average) of value within the timestamp entry.

It's funny, I tried to help you and currently have the same problem
Does anyone know how to get date histogram with average field value
within each date entry ? Standard date histogram allows to get count only
but I do not know how to get sum, avg, etc... If I have at least sum I
could get avg by myself.

Hi!
I am using elasticsearch to store a serial values of a metric like
{timestamp, value}. Now, I am trying to calculate the average of this
metric of each minute in some time range. I did this by a filter to get all
docs in that minute and calculate the avg and then the next minute. So I
have to do a searching for every minute and the performance was terrible.
Is there any sugestion for a better algorithm for better performance? Thank
you for any comment!

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.