Hi,
How to find the Sum, Average,Product of the values like MySql
in Elasticsearch for the given sample?
SELECT (SUM(Sales)/(COUNT(Items)*(Tax))) Prominence FROM Test;
cheers!
George
Hi,
How to find the Sum, Average,Product of the values like MySql
in Elasticsearch for the given sample?
SELECT (SUM(Sales)/(COUNT(Items)*(Tax))) Prominence FROM Test;
cheers!
George
Take a look at Statistical Facethttp://www.elasticsearch.org/guide/reference/api/search/facets/statistical-facet.html
.
On Monday, July 16, 2012 7:59:47 AM UTC-4, George Viju wrote:
Hi,
How to find the Sum, Average,Product of the values like MySql
in Elasticsearch for the given sample?SELECT (SUM(Sales)/(COUNT(Items)*(Tax))) Prominence FROM Test;
cheers!
George
© 2020. All Rights Reserved - Elasticsearch
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.