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

[xuqianjin (JIRA)]

     [ 
https://issues.apache.org/jira/browse/FLINK-10926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

xuqianjin updated FLINK-10926:
------------------------------
    Description: 
Use the following SQL statement:

{{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

  was:
Use the following SQL statement:

{{select TIMESTAMPDIFF (MINUTE, '2012-08-24 09:00:00', '2012-08-30 12:00:00')}}

Expect to be able to return the time difference correctly

!image-2018-11-19-18-33-47-389.png!


> 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
>            Reporter: xuqianjin
>            Priority: Minor
>         Attachments: image-2018-11-19-18-33-47-389.png
>
>
> Use the following SQL statement:
> {{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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)