[
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)
