[FLINK-10926] Fix the problem for function TIMESTAMPDIFF in Table

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.6.2
• Fix Version/s: 1.7.0
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: Forward Xu
• Created: 19/Nov/18 10:07
• Updated: 22/Nov/18 06:02
• Resolved: 22/Nov/18 06:02

Description

Use the following SQL statement:

val result3 = tEnv.sqlQuery("select TIMESTAMPDIFF(MINUTE,'2012-08-24 09:00:00','2012-08-30 12:00:00')")

The following errors occurred:

Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 72: No match found for function signature TIMESTAMPDIFF(<null>, <CHARACTER>, <CHARACTER>)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Expect to be able to return the time difference correctly

 

val result3 = tEnv.sqlQuery("select TIMESTAMPDIFF (MINUTE, TIMESTAMP '2012-08-24 09:00:00', TIMESTAMP '2012-08-30 12:00:00')")

Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 95: No match found for function signature TIMESTAMPDIFF(<null>, <TIMESTAMP>, <TIMESTAMP>)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)