[teiid-issues] [JBoss JIRA] (TEIID-3270) Allow UDFs to call Teiid functions
[
https://issues.jboss.org/browse/TEIID-3270?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3270:
---------------------------------------
Right, but to fully define a UDF, the JAVA_CLASS and JAVA_METHODS
properties need to be defined so that the Teiid engine knows what to execute when the
function is called in a SQL statement.
No, the intent of this feature is to allow a virtual function that can be defined using
the teiid procedure language.
Interestingly, EXECing the function works, but does not return a
result set, but a scalar, so the only way I found to get to the result is something like
this:
Under the covers it is defined first as a procedure and then special handling is added to
allow calling as a function. We are not specifically shutting off the procedural aspect
for calling the function.
Allow UDFs to call Teiid functions
----------------------------------
Key: TEIID-3270
URL: https://issues.jboss.org/browse/TEIID-3270
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Sanjeev Gour
Assignee: Steven Hawkins
Fix For: 8.11
Currently custom functions require the implementation on be in Java, there could be an
alternative way to allow using Teiid expressions inside the custom functions. The related
thread is here-
https://developer.jboss.org/thread/251179
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)