[
https://issues.apache.org/jira/browse/ASTERIXDB-2521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16784924#comment-16784924
]
ASF subversion and git services commented on ASTERIXDB-2521:
------------------------------------------------------------
Commit d10383f95745ba25f93ec4b517bfb806635dc1c8 in asterixdb's branch
refs/heads/master from Dmitry Lychagin
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=d10383f ]
[ASTERIXDB-2521][COMP] Add rule to eliminate isomorphic subplans
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
- Add optimizer rule that finds two isomorphic subplans
and eliminates one of them
Change-Id: I1142ea4805e7508a5d0a778081093504cf4f526a
Reviewed-on: https://asterix-gerrit.ics.uci.edu/3238
Sonar-Qube: Jenkins <[email protected]>
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Contrib: Jenkins <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> 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)
