[
https://issues.apache.org/jira/browse/FLINK-10926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xuqianjin closed FLINK-10926.
-----------------------------
Resolution: Fixed
Fix Version/s: 1.7.0
> Fix the problem for function TIMESTAMPDIFF in Table
> ---------------------------------------------------
>
> Key: FLINK-10926
> URL: https://issues.apache.org/jira/browse/FLINK-10926
> Project: Flink
> Issue Type: Bug
> Components: Table API & SQL
> Affects Versions: 1.6.2
> Reporter: xuqianjin
> Priority: Minor
> Fix For: 1.7.0
>
> Attachments: image-2018-11-19-18-33-47-389.png,
> image-2018-11-19-22-23-09-554.png
>
>
> 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)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
