You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ian Maxon (JIRA)" <ji...@apache.org> on 2016/02/22 23:10:18 UTC

[jira] [Created] (ASTERIXDB-1317) avg() does not work on open lists

Ian Maxon created ASTERIXDB-1317:
------------------------------------

             Summary: avg() does not work on open lists
                 Key: ASTERIXDB-1317
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1317
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: AsterixDB, Functions - AQL
            Reporter: Ian Maxon


This query:
 
for $i in dataset HRM_binned_clipped return {
"row_id": $i.row_id,
"sid": $i.sid,
"gdate": $i.gdate,
"gday": $i.gday,
"timebin": $i.timebin,
"stdv_RR_clipped": avg($i.RR_clipped)
}

Where the dataset is an open type, will fail when trying to compute the average of stdv_RR_clipped, with this message:

Type of argument in function-call: asterix:avg, Args:[function-call: asterix:field-access-by-name, Args:[%0->$$0, AString: {RR_clipped}]] should be a collection type instead of ANY [AlgebricksException]




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)