+ Looping in the dev list to try and get fast attention to the fix, if
it's easy!
(I know that Namarata's under time pressure in a NASA bakeoff exercise. :-))
On 12/7/15 4:59 AM, Wail Alkowaileet wrote:
It's an easy fix...
Thanks for reporting that.
I reported it in https://issues.apache.org/jira/browse/ASTERIXDB-1216
On Mon, Dec 7, 2015 at 3:33 PM, Wail Alkowaileet <[email protected]
<mailto:[email protected]>> wrote:
Hi Namrata,
The best way to think of /for /in lists is to think it works as
foreach in java.
So ..
in your first query, it should be like:
let $l := [[1.2, 2.3, 3.4],[6,3,7,2]]
for $x in $l // for each list in the outer list
return {"avg”: avg($y)}
However, I tried it and it seems that there is a bug for
applying aggregation on nested open field.
I'll look into it to see if it's an easy fix
On Mon, Dec 7, 2015 at 2:52 PM, Malarout, Namrata (398M-Affiliate)
<[email protected]
<mailto:[email protected]>> wrote:
Hi,
I am trying to perform avg, sum, min and max functions on a
collection of ordered lists. An example is:
let $l := [[1.2, 2.3, 3.4],[6,3,7,2]]
return {"avg”: avg($l)}
I have tried both avg and sql-avg. But I get the following error:
Cannot compute AVG for values of type ORDEREDLIST
[NotImplementedException].
I’ve attached the sample data that I’m working with
(sample.adm). My AQL query to find the average of
analysis_error looks like:
use dataverse Test;
for $f in dataset sample
where not(is-null($f.analysis_error))
return avg($f.analysis_error);
The error seen is as follows:
Type of argument in function-call: asterix:avg,
Args:[function-call: asterix:field-access-by-name,
Args:[%0->$$0, AString: {analysis_error}]] should be a
collection type instead of ANY [AlgebricksException]
I would like to know what is the correct syntax to find the
average. Appreciate the help.
Thanks,
Namrata
--
*Regards,*
Wail Alkowaileet
--
*Regards,*
Wail Alkowaileet
