[FLINK-10795] STDDEV_POP error

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.6.2
• Component/s: Table SQL / Legacy Planner
• Labels: auto-unassigned
• Assignee: Unassigned
• Reporter: Flavio Pompermaier
• Created: 05/Nov/18 13:37
• Updated: 05/Jul/21 13:37
• Resolved: 05/Jul/21 13:37

Description

if using STDDEV_POP in the attached job the following error is thrown (with Flink 1.6.1):

 

Exception in thread "main" org.apache.flink.runtime.client.JobExecutionException: java.lang.NumberFormatException
 at org.apache.flink.runtime.minicluster.MiniCluster.executeJobBlocking(MiniCluster.java:623)
 at org.apache.flink.client.LocalExecutor.executePlan(LocalExecutor.java:235)
 at org.apache.flink.api.java.LocalEnvironment.execute(LocalEnvironment.java:91)
 at org.apache.flink.api.java.ExecutionEnvironment.execute(ExecutionEnvironment.java:816)
 at org.apache.flink.api.java.DataSet.collect(DataSet.java:413)
 at org.apache.flink.api.java.DataSet.print(DataSet.java:1652)
 at it.okkam.datalinks.batch.flink.operations.FlinkTableApiError.main(FlinkTableApiError.java:466)
Caused by: java.lang.NumberFormatException
 at java.math.BigDecimal.<init>(BigDecimal.java:494)
 at java.math.BigDecimal.<init>(BigDecimal.java:383)
 at java.math.BigDecimal.<init>(BigDecimal.java:806)
 at java.math.BigDecimal.valueOf(BigDecimal.java:1274)
 at org.apache.calcite.runtime.SqlFunctions.sround(SqlFunctions.java:1242)
 at DataSetCalcRule$6909.flatMap(Unknown Source)
 at org.apache.flink.table.runtime.FlatMapRunner.flatMap(FlatMapRunner.scala:52)
 at org.apache.flink.table.runtime.FlatMapRunner.flatMap(FlatMapRunner.scala:31)
 at org.apache.flink.runtime.operators.chaining.ChainedFlatMapDriver.collect(ChainedFlatMapDriver.java:80)
 at org.apache.flink.runtime.operators.util.metrics.CountingCollector.collect(CountingCollector.java:35)
 at DataSetSingleRowJoinRule$6450.join(Unknown Source)
 at org.apache.flink.table.runtime.MapJoinLeftRunner.flatMap(MapJoinLeftRunner.scala:35)
 at org.apache.flink.runtime.operators.FlatMapDriver.run(FlatMapDriver.java:109)
 at org.apache.flink.runtime.operators.BatchTask.run(BatchTask.java:503)
 at org.apache.flink.runtime.operators.BatchTask.invoke(BatchTask.java:368)
 at org.apache.flink.runtime.taskmanager.Task.run(Task.java:711)
 at java.lang.Thread.run(Thread.java:748)