I have yet to use aggregations (still on facets), so I am making
assumptions here. Your field is a string ("0.03%"), so the average cannot
be computed. Since you pass in a script, you can try doing some string
manipulation, and perhaps converting to a numeric field if it is required.
Something like: doc['CPU_USED'].value.replace("%", "") (not tested)
--
Ivan
On Fri, May 23, 2014 at 12:26 AM, Subhadip Bagui <[email protected]> wrote:
> Thanks a lot Ivan. Will try with Java API as u suggested.
>
> One more doubt. There is a field in my document like "CPU_USED": "0.03%"
> Can we do aggregation avg on this field ? I tried but got exception like
> below as this was a string field. Can u please suggest.
>
> "reason": "QueryPhaseExecutionException[[virtualmachines][2]:
> query[filtered(CLOUD_TYPE:cloudstack)->cache(NODE_CREATE_TIME:[1400767895000
> TO 1400769215999])],from[0],size[0]: Query Failed [Failed to execute main
> query]]; nested: AggregationExecutionException[Unsupported script value
> [0.03]]; "
> *Query :*
> POST /virtualmachines/_search
> {
> "query" : {
> "filtered" : {
> "query" : { "match" : {
> "CLOUD_TYPE" : "CLOUDSTACK"
> }},
> "filter" : {
> "range" : { "NODE_CREATE_TIME" : { "from" : "2014-05-22
> 14:11:35", "to" : "2014-05-22 14:33:35" }}
> }
> }
> },
> "aggs" : {
> "avg_grade" : { "avg" : { "script" : "doc['CPU_USED'].value" } }
> },
> "size": 0
> }
>
> --
> 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 [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/bd12c67b-9369-4231-90ec-a818a6e9be9a%40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/bd12c67b-9369-4231-90ec-a818a6e9be9a%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQAM%2BxOoXFRRs59WdLHYfa0P0RjOnuXZp1a1VPpa_qgjQQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
