You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2019/08/13 00:38:00 UTC

[jira] [Commented] (ASTERIXDB-2611) Some aggregation queries fail when some partitions are empty

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

ASF subversion and git services commented on ASTERIXDB-2611:
------------------------------------------------------------

Commit 45b31ce84c8a5dfda2664c97529710887db8df19 in asterixdb's branch refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=45b31ce ]

[ASTERIXDB-2611][*DB] Fix GroupAll with empty input

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
This patch is to fix the issue with group by all where
some partitions are empty. The patch in general handles
propagating outer scope variables through group by all by using
subplans instead of using decor variables when translating
the AST.

- changed IsomorphismVariableMappingVisitor to stop re-visiting
  the same nested tuple operator pair again
- moved getFdColumns() up in hierarchy to be shared by others
- added a check to prevent group-all with decoration fields

Change-Id: I56916fc60c696f6c702717210f108f2247b2a397
Reviewed-on: https://asterix-gerrit.ics.uci.edu/3521
Contrib: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Reviewed-by: Dmitry Lychagin <dm...@couchbase.com>


> Some aggregation queries fail when some partitions are empty
> ------------------------------------------------------------
>
>                 Key: ASTERIXDB-2611
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2611
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: RT - Runtime
>    Affects Versions: 0.9.4
>            Reporter: Ali Alsuliman
>            Assignee: Ali Alsuliman
>            Priority: Major
>             Fix For: 0.9.5
>
>
> The below query fails if some partitions are empty. The cause is that the aggregator for empty partitions does not get the chance to produce a proper output because the nested plan pipeline is not opened.
> {code:java}USE TinySocial;
> WITH t AS 1
> SELECT count(`friend-ids`), t
> FROM FacebookUsers;{code}



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)