-
1. Re: registering a non-pushdown udf in embedded teiid
rareddy Jul 3, 2015 1:23 PM (in response to mickalas)Mick,
Creating UDF in VDB is same in embedded and Server versions. You need to define the UDF on a View/Virtual model along with its required see https://docs.jboss.org/author/display/TEIID/Support+for+User-Defined+Functions+%28Non-Pushdown%29
The only difference is, the JAR file for UDF needs to be in classpath in embedded, where as in Server it needs to be defined in "lib" or module.
Ramesh..
-
2. Re: registering a non-pushdown udf in embedded teiid
mickalas Jul 8, 2015 6:50 AM (in response to rareddy)Thanks for the reply.
I was looking for a programmatic way to register non-pushdown functions as we are not using XML descriptor to descibe VDB. Maybe I am doing something wrong but we are using VDB registration as outlined here on this page - https://docs.jboss.org/author/display/TEIID/Embedded+Guide
On further inspection I can see I can register the function as a FunctionMethod using MetadataFactory.addFunction and this seems to be working fine for me.
Cheers
Mick