Aleksey Plekhanov created IGNITE-27915:
------------------------------------------
Summary: Flaky AggregatePlannerTest.colocated[Algorithm = HASH]
Key: IGNITE-27915
URL: https://issues.apache.org/jira/browse/IGNITE-27915
Project: Ignite
Issue Type: Bug
Reporter: Aleksey Plekhanov
Assignee: Aleksey Plekhanov
Test AggregatePlannerTest.colocated[Algorithm = HASH] is flaky.
Eventually planner skips optimal join plan and produce plan like (exchange to
single):
{noformat}
IgniteProject(DEPTID=[$0], CNT=[$2]): rowcount = 37500.0, cumulative cost =
IgniteCost [rowCount=3037502.0, cpu=9475002.0, memory=5150002.0, io=2.0,
network=4000002.0], id = 48623
IgniteHashJoin(condition=[=($0, $1)], joinType=[inner], variablesSet=[[]]):
rowcount = 37500.0, cumulative cost = IgniteCost [rowCount=3000002.0,
cpu=9437502.0, memory=5150002.0, io=2.0, network=4000002.0], id = 48622
IgniteExchange(distribution=[single]): rowcount = 500000.0, cumulative cost
= IgniteCost [rowCount=1000001.0, cpu=875001.0, memory=1.0, io=1.0,
network=2000001.0], id = 48619
IgniteIndexScan(table=[[PUBLIC, DEPT]], index=[DEPTID],
requiredColumns=[{0}], inlineScan=[true], collation=[[0 ASC-nulls-first]]):
rowcount = 500000.0, cumulative cost = IgniteCost [rowCount=500001.0,
cpu=375001.0, memory=1.0, io=1.0, network=1.0], id = 47383
IgniteExchange(distribution=[single]): rowcount = 250000.0, cumulative cost
= IgniteCost [rowCount=1250001.0, cpu=1062501.0, memory=2250001.0, io=1.0,
network=2000001.0], id = 48621
IgniteColocatedHashAggregate(group=[{0}], CNT=[COUNT()]): rowcount =
250000.0, cumulative cost = IgniteCost [rowCount=1000001.0, cpu=812501.0,
memory=2250001.0, io=1.0, network=1.0], id = 48620
IgniteIndexScan(table=[[PUBLIC, EMP]], index=[DEPTID],
requiredColumns=[{1}], inlineScan=[true], collation=[[1 ASC-nulls-first]]):
rowcount = 500000.0, cumulative cost = IgniteCost [rowCount=500001.0,
cpu=312501.0, memory=1.0, io=1.0, network=1.0], id = 47348
{noformat}
It caused by https://issues.apache.org/jira/browse/IGNITE-16334 and root cause
can be fixed in Apache Calcite. Until this fix it's proposed to ignore this
test.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
