You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "jamie12221 (Jira)" <ji...@apache.org> on 2020/06/05 07:39:00 UTC
[jira] [Created] (CALCITE-4045)
ReduceExpressionsRule$JoinReduceExpressionsRule(java.lang.IndexOutOfBoundsException:
Index: 0, Size: 0)
jamie12221 created CALCITE-4045:
-----------------------------------
Summary: ReduceExpressionsRule$JoinReduceExpressionsRule(java.lang.IndexOutOfBoundsException: Index: 0, Size: 0)
Key: CALCITE-4045
URL: https://issues.apache.org/jira/browse/CALCITE-4045
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.23.0
Reporter: jamie12221
{code:java}
[DEBUG] EXPLAIN select (select c.id from db1.company as c where c.id = t.id limit 0 ,10000) from db1.travelrecord as t where t.id = 1 LIMIT 500 ,10000
15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql.parser toTree at 641]-[DEBUG] Reduced `c`.`id` = `t`.`id`
15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql.parser toTree at 641]-[DEBUG] Reduced `t`.`id` = 1
15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql2rel convertQuery at 581]-[DEBUG] Plan after converting SqlNode to RelNode
LogicalSort(offset=[500], fetch=[10000])
LogicalProject(EXPR$0=[$6])
LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{0}])
LogicalFilter(condition=[=($0, 1)])
LogicalTableScan(table=[[db1, travelrecord]])
LogicalAggregate(group=[{}], agg#0=[SINGLE_VALUE($0)])
LogicalSort(offset=[0], fetch=[10000])
LogicalProject(id=[$0])
LogicalFilter(condition=[=(CAST($0):BIGINT, $cor0.id)])
LogicalTableScan(table=[[db1, company]])15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary dumpRuleAttemptsInfo at 295]-[DEBUG] Rule Attempts Info for HepPlanner
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary dumpRuleAttemptsInfo at 296]-[DEBUG]
Rules Attempts Time (us)15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#266:LogicalSort.NONE.[](input=HepRelVertex#265,offset=500,fetch=10000)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#264:LogicalProject.NONE.[](input=HepRelVertex#263,exprs=[$6])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#262:LogicalCorrelate.NONE.[](left=HepRelVertex#252,right=HepRelVertex#261,correlation=$cor0,joinType=left,requiredColumns={0})
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#251:LogicalFilter.NONE.[](input=HepRelVertex#250,condition==(1, $0))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#238:LogicalTableScan.NONE.[](table=[db1, travelrecord])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#260:LogicalAggregate.NONE.[](input=HepRelVertex#259,group={},agg#0=SINGLE_VALUE($0))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#258:LogicalSort.NONE.[](input=HepRelVertex#257,offset=0,fetch=10000)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#256:LogicalProject.NONE.[](input=HepRelVertex#255,inputs=0)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#254:LogicalFilter.NONE.[](input=HepRelVertex#253,condition==($cor0.id, CAST($0):BIGINT))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#240:LogicalTableScan.NONE.[](table=[db1, company])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql2rel decorrelateQuery at 210]-[DEBUG] Plan after removing Correlator
LogicalSort(offset=[500], fetch=[10000])
LogicalProject(EXPR$0=[$6])
LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{0}])
LogicalFilter(condition=[=($0, 1)])
LogicalTableScan(table=[[db1, travelrecord]])
LogicalAggregate(group=[{}], agg#0=[SINGLE_VALUE($0)])
LogicalSort(offset=[0], fetch=[10000])
LogicalProject(id=[$0])
LogicalFilter(condition=[=(CAST($0):BIGINT, $cor0.id)])
LogicalTableScan(table=[[db1, company]])15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule at 324]-[DEBUG] call#62: Apply rule [AdjustProjectForCountAggregateRule] to [rel#280:LogicalCorrelate.NONE.[](left=HepRelVertex#270,right=HepRelVertex#279,correlation=$cor0,joinType=left,requiredColumns={0}), rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)), rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))]
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyTransformation at 364]-[DEBUG] call#62: Rule AdjustProjectForCountAggregateRule arguments [rel#280:LogicalCorrelate.NONE.[](left=HepRelVertex#270,right=HepRelVertex#279,correlation=$cor0,joinType=left,requiredColumns={0}), rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)), rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))] produced rel#288:LogicalProject#288
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule at 324]-[DEBUG] call#63: Apply rule [AdjustProjectForCountAggregateRule] to [rel#291:LogicalCorrelate.NONE.[](left=HepRelVertex#289,right=HepRelVertex#290,correlation=$cor0,joinType=left,requiredColumns={0}), rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)), rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))]
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule at 324]-[DEBUG] call#64: Apply rule [AdjustProjectForCountAggregateRule] to [rel#291:LogicalCorrelate.NONE.[](left=HepRelVertex#289,right=HepRelVertex#290,correlation=$cor0,joinType=left,requiredColumns={0}), rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)), rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))]
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary dumpRuleAttemptsInfo at 295]-[DEBUG] Rule Attempts Info for HepPlanner
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary dumpRuleAttemptsInfo at 296]-[DEBUG]
Rules Attempts Time (us)
AdjustProjectForCountAggregateRule 3 7,17715:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#284:LogicalSort.NONE.[](input=HepRelVertex#283,offset=500,fetch=10000)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#282:LogicalProject.NONE.[](input=HepRelVertex#281,exprs=[$6])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#293:LogicalProject.NONE.[](input=HepRelVertex#292,inputs=0..6)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#291:LogicalCorrelate.NONE.[](left=HepRelVertex#289,right=HepRelVertex#290,correlation=$cor0,joinType=left,requiredColumns={0})
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#238:LogicalTableScan.NONE.[](table=[db1, travelrecord])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#276:LogicalSort.NONE.[](input=HepRelVertex#275,offset=0,fetch=10000)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#274:LogicalProject.NONE.[](input=HepRelVertex#273,inputs=0)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#272:LogicalFilter.NONE.[](input=HepRelVertex#271,condition==($cor0.id, CAST($0):BIGINT))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#240:LogicalTableScan.NONE.[](table=[db1, company])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule at 324]-[DEBUG] call#65: Apply rule [FilterJoinRule:FilterJoinRule:no-filter] to [rel#324:LogicalJoin.NONE.[](left=HepRelVertex#310,right=HepRelVertex#323,condition==($0, $6),joinType=left)]
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary dumpRuleAttemptsInfo at 295]-[DEBUG] Rule Attempts Info for HepPlanner
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary dumpRuleAttemptsInfo at 296]-[DEBUG]
Rules Attempts Time (us)
FilterJoinRule:FilterJoinRule:no-filter 1 1,04315:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#328:LogicalSort.NONE.[](input=HepRelVertex#327,offset=500,fetch=10000)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#326:LogicalProject.NONE.[](input=HepRelVertex#325,exprs=[$7])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#324:LogicalJoin.NONE.[](left=HepRelVertex#310,right=HepRelVertex#323,condition==($0, $6),joinType=left)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#309:LogicalFilter.NONE.[](input=HepRelVertex#308,condition==(1, $0))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#238:LogicalTableScan.NONE.[](table=[db1, travelrecord])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#322:LogicalAggregate.NONE.[](input=HepRelVertex#321,group={0},agg#0=SINGLE_VALUE($1))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#320:LogicalProject.NONE.[](input=HepRelVertex#319,exprs=[$1, $0])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#318:LogicalSort.NONE.[](input=HepRelVertex#317,fetch=10000)
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#316:LogicalProject.NONE.[](input=HepRelVertex#315,inputs=0,exprs=[$3])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#314:LogicalFilter.NONE.[](input=HepRelVertex#313,condition==($3, CAST($0):BIGINT))
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#312:LogicalProject.NONE.[](input=HepRelVertex#311,inputs=0..2,exprs=[CAST($0):BIGINT])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final plan, using rel#240:LogicalTableScan.NONE.[](table=[db1, company])
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule at 324]-[DEBUG] call#66: Apply rule [ReduceExpressionsRule(Project)] to [rel#348:LogicalProject.NONE.[](input=HepRelVertex#347,exprs=[$7])]
15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule at 324]-[DEBUG] call#67: Apply rule [ReduceExpressionsRule(Join)] to [rel#346:LogicalJoin.NONE.[](left=HepRelVertex#332,right=HepRelVertex#345,condition==($0, $6),joinType=left)]
{code}
{code:java}
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck(ArrayList.java:657) at java.util.ArrayList.get(ArrayList.java:433) at org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visit(ReduceExpressionsRule.java:858) at org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitInputRef(ReduceExpressionsRule.java:837) at org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitInputRef(ReduceExpressionsRule.java:816) at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:112) at org.apache.calcite.rex.RexShuttle.visitList(RexShuttle.java:159) at org.apache.calcite.rex.RexShuttle.visitCall(RexShuttle.java:111) at org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitCall(ReduceExpressionsRule.java:849) at org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitCall(ReduceExpressionsRule.java:816) at org.apache.calcite.rex.RexCall.accept(RexCall.java:288) at org.apache.calcite.rex.RexShuttle.apply(RexShuttle.java:287) at org.apache.calcite.rex.RexShuttle.mutate(RexShuttle.java:249) at org.apache.calcite.rel.rules.ReduceExpressionsRule.reduceExpressionsInternal(ReduceExpressionsRule.java:701) at org.apache.calcite.rel.rules.ReduceExpressionsRule.reduceExpressions(ReduceExpressionsRule.java:620) at org.apache.calcite.rel.rules.ReduceExpressionsRule$JoinReduceExpressionsRule.onMatch(ReduceExpressionsRule.java:347) at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:338) at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:540) at org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:405) at org.apache.calcite.plan.hep.HepPlanner.executeInstruction(HepPlanner.java:270) at org.apache.calcite.plan.hep.HepInstruction$RuleCollection.execute(HepInstruction.java:74) at org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:201) at org.apache.calcite.plan.hep.HepPlanner.findBestExp(HepPlanner.java:188)
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)