Hi,

Is is possible to define a UDF in java, make is return a user defined data type? For example, in myUDF, I would do:

1. Select int 1, String2 from table1 where id=inputId;

2. javaObject myObj=new javaObject(int1, String2);

3. set(outputParamIndex, myObj);

I have been reading other thread, and seems step 1 is quite promising, how about step 3?

Also, in my caller function, is it possible to do
select id, myUDF(id) from table1 ? How can I access the object returned by myUDF?

Thank you for your attention!