Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-10926

Fix the problem for function TIMESTAMPDIFF in Table

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None

      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)

        Attachments

        1. image-2018-11-19-22-23-09-554.png
          139 kB
          Forward Xu
        2. image-2018-11-19-18-33-47-389.png
          118 kB
          Forward Xu

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              x1q1j1 Forward Xu
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: