You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "xuqianjin (JIRA)" <ji...@apache.org> on 2018/11/22 06:03:00 UTC

[jira] [Closed] (FLINK-10926) Fix the problem for function TIMESTAMPDIFF in Table

     [ 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 &amp; 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)