]
Steven Hawkins commented on TEIIDDES-992:
-----------------------------------------
there are two straight-forward paths toward making source specific pushdown functions
definable in designer
1. merge the function and relational metamodels (functions could then be indexed as
prodedures with the isfunction flag set)
2. allow function models to be assigned to sources just like physical models
Either could then be interpreted by the runtime as the definition of pushdown functions
with only minor changes.
The only usecase that is complex with this approach is having the same function in
multiple sources being treated semantically the same (like a global udf). This is already
a somewhat complicated issue currently, which I can expand on separately. This however
could be handled most easily by allowing a function or function model to be assigned to
more than 1 source.
Allow the use of pushdown functions without requiring Java
programming
----------------------------------------------------------------------
Key: TEIIDDES-992
URL:
https://issues.jboss.org/browse/TEIIDDES-992
Project: Teiid Designer
Issue Type: Feature Request
Reporter: Bernd Groh
Currently, in order to use a database function, even if pushdown is required, it is still
necessary to add the function interface to a Java class within the connector, and the
connector then must be deployed to the server in order to allow for this pushdown function
to be used within the Designer. This creates a lot of extra effort every time you want to
make use of a new database function. Particularly, given the schema designer doesn't
necessarily have access to either the connector code or the server, and then must involve
other parties simply to be able to use an additional database function. It would be very
beneficial to speedy schema development if that was not necessary, and if, say, the
interface could be defined on the Designer side, added to the VDB, and then deployed as
part of the VDB.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: