Anonymous Coward (816) has posted comments on this change. (
http://gerrit.cloudera.org:8080/21961 )
Change subject: IMPALA-13468: Fix various aggregation issues in aggregation.test
......................................................................
Patch Set 5:
> create table correlated_scalar_t1(c1 bigint, c2 bigint);
> create table correlated_scalar_t2(c1 bigint, c2 bigint);
> insert into correlated_scalar_t1 values (1,null),(null,1),(1,2),
> (null,2),(1,3), (2,4), (2,5), (3,3), (3,4), (20,2), (22,3),
> (24,4),(null,null);
> insert into correlated_scalar_t2 values (1,null),(null,1),(1,4),
> (1,2), (null,3), (2,4), (3,7), (3,9),(null,null),(5,1);
> select c1 from correlated_scalar_t1 where correlated_scalar_t1.c2 >
> (select c1 from correlated_scalar_t2 where correlated_scalar_t1.c1
> = correlated_scalar_t2.c1 and correlated_scalar_t2.c2 < 4) order by
> c1;
>
> I1023 19:56:24.310750 1989386 CalciteOptimizer.java:184]
> 044892e8f77df486:abfd3cda00000000] [Impala plan]
> LogicalSort(sort0=[$0], dir0=[ASC]), id = 717
> LogicalProject(C1=[$0]), id = 716
> LogicalJoin(condition=[AND(=($0, $2), >($1, $3))],
> joinType=[inner]), id = 715
> LogicalTableScan(table=[[default, correlated_scalar_t1]]), id = 547
> LogicalAggregate(group=[{0}], agg#0=[SINGLE_VALUE($1)]), id = 714
> LogicalProject(c11=[$0], C1=[$0]), id = 713
> LogicalFilter(condition=[AND(<($1, 4), IS NOT NULL($0))]), id = 712
> LogicalTableScan(table=[[default, correlated_scalar_t2]]), id = 549
>
>
> I1023 19:56:24.312273 1989386 CalciteJniFrontend.java:174]
> 044892e8f77df486:abfd3cda00000000] Optimized logical plan
> I1023 19:56:24.312394 1989386 CalciteMetadataHandler.java:202]
> 044892e8f77df486:abfd3cda00000000] Loaded tables: correlated_scalar_t1,
> correlated_scalar_t2
> I1023 19:56:24.312475 1989386 AuthorizationUtil.java:100]
> 044892e8f77df486:abfd3cda00000000] Authorization is 'DISABLED'.
> I1023 19:56:24.333379 1989386 CalciteJniFrontend.java:123]
> 044892e8f77df486:abfd3cda00000000] Calcite planner failed.
> I1023 19:56:24.333417 1989386 CalciteJniFrontend.java:124]
> 044892e8f77df486:abfd3cda00000000] Exception:
> java.lang.IndexOutOfBoundsException:
> Index: 3, Size: 3
> I1023 19:56:24.333540 1989386 CalciteJniFrontend.java:126]
> 044892e8f77df486:abfd3cda00000000] Stack
> Trace:java.lang.IndexOutOfBoundsException:
> Index: 3, Size: 3
> at java.util.ArrayList.rangeCheck(ArrayList.java:659)
> at java.util.ArrayList.get(ArrayList.java:435)
> at
> org.apache.impala.calcite.rel.util.CreateExprVisitor.visitInputRef(CreateExprVisitor.java:51)
> at
> org.apache.impala.calcite.rel.util.CreateExprVisitor.visitInputRef(CreateExprVisitor.java:33)
> at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:125)
> at
> org.apache.impala.calcite.rel.util.CreateExprVisitor.visitCall(CreateExprVisitor.java:58)
> at
> org.apache.impala.calcite.rel.util.CreateExprVisitor.visitCall(CreateExprVisitor.java:33)
> at org.apache.calcite.rex.RexCall.accept(RexCall.java:189)
> at
> org.apache.impala.calcite.rel.node.ImpalaJoinRel.getConditionConjuncts(ImpalaJoinRel.java:412)
> at
> org.apache.impala.calcite.rel.node.ImpalaJoinRel.getPlanNode(ImpalaJoinRel.java:101)
> at
> org.apache.impala.calcite.rel.node.ImpalaProjectRel.getChildPlanNode(ImpalaProjectRel.java:117)
> at
> org.apache.impala.calcite.rel.node.ImpalaProjectRel.getPlanNode(ImpalaProjectRel.java:62)
> at
> org.apache.impala.calcite.rel.node.ImpalaSortRel.getChildPlanNode(ImpalaSortRel.java:141)
> at
> org.apache.impala.calcite.rel.node.ImpalaSortRel.getPlanNode(ImpalaSortRel.java:84)
> at
> org.apache.impala.calcite.service.CalcitePhysPlanCreator.create(CalcitePhysPlanCreator.java:51)
> at
> org.apache.impala.calcite.service.CalciteJniFrontend.createExecRequest(CalciteJniFrontend.java:108)
> I1023 19:56:24.333645 1989386 jni-util.cc:288]
> 044892e8f77df486:abfd3cda00000000]
> org.apache.impala.common.InternalException: Index: 3, Size: 3
> at
> org.apache.impala.calcite.service.CalciteJniFrontend.createExecRequest(CalciteJniFrontend.java:127)
> I1023 19:56:24.333654 1989386 status.cc:129]
> 044892e8f77df486:abfd3cda00000000]
> InternalException: Index: 3, Size: 3
> @ 0x11f6c5d impala::Status::Status()
> @ 0x1b579e6 impala::JniUtil::GetJniExceptionMsg()
> @ 0x183b922 impala::JniCall::Call<>()
> @ 0x180e86a impala::Frontend::GetExecRequest()
> @ 0x252d1d4 impala::QueryDriver::RunFrontendPlanner()
> @ 0x18a7fd5 impala::ImpalaServer::ExecuteInternal()
> @ 0x18a9459 impala::ImpalaServer::Execute()
> @ 0x1a58c54 impala::ImpalaServer::ExecuteStatementCommon()
> @ 0x1a5a4a2 impala::ImpalaServer::ExecuteStatement()
> @ 0x192e001
> apache::hive::service::cli::thrift::TCLIServiceProcessorT<>::process_ExecuteStatement()
> @ 0x19aa96d
> apache::hive::service::cli::thrift::TCLIServiceProcessorT<>::dispatchCall()
> @ 0x19aaf12
> impala::ImpalaHiveServer2ServiceProcessorT<>::dispatchCall()
> @ 0x107e985 apache::thrift::TDispatchProcessor::process()
> @ 0x1563a13 apache::thrift::server::TAcceptQueueServer::Task::run()
> @ 0x15560a1 impala::ThriftThread::RunRunnable()
> @ 0x1557d4d
> boost::detail::function::void_function_obj_invoker0<>::invoke()
> @ 0x1c356bc impala::Thread::SuperviseThread()
> @ 0x1c364c5 boost::detail::thread_data<>::run()
> @ 0x29b57e7 thread_proxy
> @ 0x7f091f5331ca start_thread
> @ 0x7f091b80d8d3 __GI___clone
This test case may be unrelated to this pr; it's a scalar subquery test case,
but it is indeed a problem.
--
To view, visit http://gerrit.cloudera.org:8080/21961
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings
Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: comment
Gerrit-Change-Id: I038127d6a2f228ae8d263e983b1906e99ae05f77
Gerrit-Change-Number: 21961
Gerrit-PatchSet: 5
Gerrit-Owner: Steve Carlin <[email protected]>
Gerrit-Reviewer: Aman Sinha <[email protected]>
Gerrit-Reviewer: Anonymous Coward (816)
Gerrit-Reviewer: Impala Public Jenkins <[email protected]>
Gerrit-Reviewer: Joe McDonnell <[email protected]>
Gerrit-Reviewer: Michael Smith <[email protected]>
Gerrit-Reviewer: Steve Carlin <[email protected]>
Gerrit-Comment-Date: Thu, 24 Oct 2024 06:13:01 +0000
Gerrit-HasComments: No
