[jira] [Commented] (ASTERIXDB-2521) Out of memory error trying to do multiple aggregates using WITH clause

["Dmitry Lychagin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-2521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16777168#comment-16777168 ] 

Dmitry Lychagin commented on ASTERIXDB-2521:
--------------------------------------------

Yes, there're a couple of listifys in the plan. We need to understand whether they can be eliminated. 

> Out of memory error trying to do multiple aggregates using WITH clause
> ----------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2521
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2521
>             Project: Apache AsterixDB
>          Issue Type: Bug
>    Affects Versions: 0.9.5
>            Reporter: Gift Sinthong
>            Assignee: Dmitry Lychagin
>            Priority: Major
>         Attachments: cc.log, nc-1.log, plan.txt
>
>
> I was trying to find a standard deviation value and also include other aggregated values (e.g. min, max, count), it gave the "Out of memory error".
> I attach the cc and nc logs here along with the query plan. Here is the query that I used.
> WITH info AS (SELECT avg(t.unique1) AS mean, min(t.unique1) AS min
> FROM wisconsin t )[0]
> SELECT sqrt(avg(square)) std
> FROM (SELECT VALUE power(info.mean - t.unique1, 2) 
> FROM wisconsin t) square;
> Note: When I ran the query without the "min(t.unique1) AS min", it worked fine.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)