[BEAM-9662] BeamSortRule NullPointerException limit parameter

• Type: Bug
• Status: Resolved
• Priority: P1
• Resolution: Fixed
• Fix Version/s: 2.22.0
• Component/s: dsl-sql-zetasql
• Labels: zetasql-compliance
• Assignee: Andrew Pilloud
• Reporter: Andrew Pilloud
• Created: 01/Apr/20 22:19
• Updated: 16/May/20 13:30
• Resolved: 21/Apr/20 18:27

Description

one failure in shard 37

Apr 01, 2020 11:51:00 AM cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl executeQuery
SEVERE: !!!! Error while applying rule BeamSortRule, args [rel#6052:LogicalSort.NONE(input=RelSubset#6051,fetch=null:BIGINT)]
java.lang.RuntimeException: Error while applying rule BeamSortRule, args [rel#6052:LogicalSort.NONE(input=RelSubset#6051,fetch=null:BIGINT)]
	at org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:235)
	at org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:631)
	at org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:328)
	at org.apache.beam.sdk.extensions.sql.zetasql.ZetaSQLPlannerImpl.transform(ZetaSQLPlannerImpl.java:180)
	at org.apache.beam.sdk.extensions.sql.zetasql.ZetaSQLQueryPlanner.convertToBeamRelInternal(ZetaSQLQueryPlanner.java:150)
	at org.apache.beam.sdk.extensions.sql.zetasql.ZetaSQLQueryPlanner.convertToBeamRel(ZetaSQLQueryPlanner.java:115)
	at cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl.executeQuery(ExecuteQueryServiceServer.java:242)
	at com.google.zetasql.testing.SqlComplianceServiceGrpc$MethodHandlers.invoke(SqlComplianceServiceGrpc.java:423)
	at com.google.zetasql.io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:171)
	at com.google.zetasql.io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:283)
	at com.google.zetasql.io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:711)
	at com.google.zetasql.io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)
	at com.google.zetasql.io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
	at org.apache.beam.sdk.extensions.sql.impl.rel.BeamSortRel.<init>(BeamSortRel.java:132)
	at org.apache.beam.sdk.extensions.sql.impl.rule.BeamSortRule.convert(BeamSortRule.java:44)
	at org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.rel.convert.ConverterRule.onMatch(ConverterRule.java:139)
	at org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:208)
	... 15 more

Apr 01, 2020 11:51:00 AM cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl executeQuery
INFO: Processing Sql statement: SELECT a FROM (SELECT 1 a) LIMIT @lmt

Issue Links

• links to: https://github.com/apache/beam/pull/11471