Error:

org.apache.flink.client.program.ProgramInvocationException: The main method caused an error: No matching accumulate method found for AggregateFunction ‘org.apache.flink.table.planner.functions.aggfunctions.LastValueWithRetractAggFunction.LongLastValueWithRetractAggFuncti on’with parameters ‘(java.lang.Long, java.lang.Integer)’.

The code of investigation and discovery is:

last_value(coalesce(c1),-99) as c1

You need to modify it to:

last_value(coalesce(c1,-99)) as c1

Is the “) “position is wrong!!

Flinksql

end