You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Yingyi Bu (JIRA)" <ji...@apache.org> on 2016/05/24 22:51:13 UTC
[jira] [Resolved] (ASTERIXDB-1317) avg() does not work on open
lists
[ https://issues.apache.org/jira/browse/ASTERIXDB-1317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yingyi Bu resolved ASTERIXDB-1317.
----------------------------------
Resolution: Fixed
> 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
> Assignee: Yingyi Bu
>
> 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)