[
https://issues.apache.org/jira/browse/ASTERIXDB-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin updated ASTERIXDB-2612:
---------------------------------------
Description:
On a system with 2 nodes and 2 I/O devices on each node the following query
returns wrong result because of the two-step aggregate rewriting:
{noformat}
select m, array_count((from g select value g.t.unique1 limit 3)) cnt
from onektup t
group by unique2 % 2 as m group as g
order by m
{noformat}
Expected:
{noformat}
{ "m": 0, "cnt": 3 }
{ "m": 1, "cnt": 3 }
{noformat}
Actual result:
{noformat}
{ "m": 0, "cnt": 12 }
{ "m": 1, "cnt": 12 }
{noformat}
Dataset: data/wisc/onektup.adm
was:
On a system with 2 nodes and 2 I/O devices on each node the following query
returns wrong result because of the two-step aggregate rewriting:
{noformat}
select m, array_count((from g select value g.t.unique1 limit 3)) cnt
from onektup t
group by unique2 % 2 as m group as g
order by m
{noformat}
Expected:
{noformat}
{ "m": 0, "cnt": 3 }
{ "m": 1, "cnt": 3 }
{noformat}
Actual result.
{ "m": 0, "cnt": 12 }
{ "m": 1, "cnt": 12 }
Dataset: data/wisc/onektup.adm
> Incorrect result with two-step aggregate function
> -------------------------------------------------
>
> Key: ASTERIXDB-2612
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2612
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Major
>
> On a system with 2 nodes and 2 I/O devices on each node the following query
> returns wrong result because of the two-step aggregate rewriting:
> {noformat}
> select m, array_count((from g select value g.t.unique1 limit 3)) cnt
> from onektup t
> group by unique2 % 2 as m group as g
> order by m
> {noformat}
> Expected:
> {noformat}
> { "m": 0, "cnt": 3 }
> { "m": 1, "cnt": 3 }
> {noformat}
> Actual result:
> {noformat}
> { "m": 0, "cnt": 12 }
> { "m": 1, "cnt": 12 }
> {noformat}
> Dataset: data/wisc/onektup.adm
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
