Hi,
I have met a problem when using calcite 1.4 to implement a
scalarFunction for my udf.
the field type is date and I want to realize the MY_FUNC(date)
*SQL : select MY_FUNC(date) from table;*
if I set my function's argument type to java.sql.Date, calcite will
report Exception:
_/Caused by: org.codehaus.commons.compiler.CompileException: Line 124,
Column 45: No applicable constructor/method found for actual parameters
"int"; /_
if I set the function's argument type to int, calcite will report
Exception:
_/Caused by: org.apache.calcite.sql.validate.SqlValidatorException: No
match found for function signature MY_FUNCTION(<DATE>)/_
In my opinion, Now, I implement both two functions (one the arg type is
int, other's is Date ), and it can work, but I think whether there is
another better choice ? By the way , is date type must be transformed
to integer type when process the query ?
--
-------
Wei Hu
