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

["Gift Sinthong (JIRA)" <ji...@apache.org>]

Gift Sinthong created ASTERIXDB-2521:
----------------------------------------

             Summary: 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
         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 gives 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)