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


--
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: Wed, 23 Oct 2024 11:57:13 +0000
Gerrit-HasComments: No

Reply via email to