Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1041

User-defined function that returns DATE or TIMESTAMP value

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 1.6.0
        • Component/s: None
        • Labels:
          None

          Description

          In CALCITE-986 comments there are reported problems with a UDF that returns a TIMESTAMP value. Wei Hu, since that case is resolved, can you add details here?

            Issue Links

            is related to

            Bug - A problem which impairs or prevents the functions of the product. CALCITE-1075 UDF Error of Calcite 1.6

            • Major - Major loss of function.
            • Open
            relates to

            Bug - A problem which impairs or prevents the functions of the product. CALCITE-986 User-defined function with Date or Timestamp parameters

            • Major - Major loss of function.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              Droopyhu Wei Hu added a comment -

              udf is as below:
              java.sql.Timestamp myfunc(Timestamp field)

              SQL: select * from table where myFunc(field) in (cast('1970-01-01 00:00:00'), cast('1997-02-01 00:00:00'));

              calcite's generated code throw compile exception:
              Error stack:
              Caused by: java.lang.RuntimeException: Error while compiling generated Java code:
              ...............
              ..............
              at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
              at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
              at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1044)
              at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:293)
              at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:188)
              at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:669)
              at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:570)
              at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:539)
              at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:173)
              at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:504)
              at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
              at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
              ... 33 more
              Caused by: org.codehaus.commons.compiler.CompileException: Line 66, Column 101: Cannot cast "long" to "java.sql.Timestamp"
              at org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:10092)
              at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3839)
              at org.codehaus.janino.UnitCompiler.access$6400(UnitCompiler.java:183)
              at org.codehaus.janino.UnitCompiler$10.visitCast(UnitCompiler.java:3246)
              at org.codehaus.janino.Java$Cast.accept(Java.java:3802)
              the Generated Code cause Exception :
              if (v && v1 == org.apache.calcite.runtime.SqlFunctions.toLong((java.sql.Timestamp) org.apache.calcite.avatica.util.DateTimeUtils.timestampStringToUnixDate("1986-12-18 00:00:00"))

              Show
              Droopyhu Wei Hu added a comment - udf is as below: java.sql.Timestamp myfunc(Timestamp field) SQL: select * from table where myFunc(field) in (cast('1970-01-01 00:00:00'), cast('1997-02-01 00:00:00')); calcite's generated code throw compile exception: Error stack: Caused by: java.lang.RuntimeException: Error while compiling generated Java code: ............... .............. at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1044) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:293) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:188) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:669) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:570) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:539) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:173) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:504) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109) ... 33 more Caused by: org.codehaus.commons.compiler.CompileException: Line 66, Column 101: Cannot cast "long" to "java.sql.Timestamp" at org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:10092) at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3839) at org.codehaus.janino.UnitCompiler.access$6400(UnitCompiler.java:183) at org.codehaus.janino.UnitCompiler$10.visitCast(UnitCompiler.java:3246) at org.codehaus.janino.Java$Cast.accept(Java.java:3802) the Generated Code cause Exception : if (v && v1 == org.apache.calcite.runtime.SqlFunctions.toLong((java.sql.Timestamp) org.apache.calcite.avatica.util.DateTimeUtils.timestampStringToUnixDate("1986-12-18 00:00:00"))
              Hide
              Permalink
              julianhyde Julian Hyde added a comment -

              Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/d4bbf58d.

              Show
              julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/d4bbf58d .
              Hide
              Permalink
              julianhyde Julian Hyde added a comment -

              Resolved in release 1.6.0 (2016-01-22).

              Show
              julianhyde Julian Hyde added a comment - Resolved in release 1.6.0 (2016-01-22).

                People

                • Assignee:
                  julianhyde Julian Hyde
                  Reporter:
                  julianhyde Julian Hyde
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Development