weihua zhang created IMPALA-13483:
-------------------------------------
Summary: Calcite Planner: some scalar subquery throws exception
Key: IMPALA-13483
URL: https://issues.apache.org/jira/browse/IMPALA-13483
Project: IMPALA
Issue Type: Sub-task
Reporter: weihua zhang
{code:java}
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;{code}
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
may be unrelated to single_value
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
