-
1. Re: Teiid user defined Functions
shawkins Aug 2, 2016 6:27 PM (in response to hend.amin)Using DDL this it looks like DDL Metadata · Teiid Documentation:
CREATE VIRTUAL FUNCTION func(p1 bigdecimal) RETURNS integer as return <some expression>;
This is not yet supported in Teiid Designer.
A possible drawback is that currently a sql defined function is not inlined, which may inhibit pushdown if the sources aren't marked as supporting the function.
-
2. Re: Teiid user defined Functions
hend.amin Aug 8, 2016 6:13 AM (in response to shawkins)Hello Stevens,
I want to use this in my sql query for the VDB to avoid code repetition.
select getname(Id) from table;
How can i make that work? is there a possible way to make it work this way or i should wait for a fix in a future release ??
Thanks
-
3. Re: Teiid user defined Functions
shawkins Aug 8, 2016 7:34 PM (in response to hend.amin)> How can i make that work?
To clarify are you using Teiid Designer or a VDB that defines it's metadata through import / ddl? And do you want getname to pushdown to the source or just be able to be evaluated in Teiid?