Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-992

Allow the use of pushdown functions without requiring Java programming

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 7.5, 7.4.2
    • 7.4
    • None
    • None
    • Hide
      What is a 'pushdown' function?

      For standard Teiid Designer user-defined functions, the function "code" is deployed under Teiid, so the function get's executed during the Teiid Query result-set processing.The "pushdown function" relates to "pushing down" the SQL that contains the function call as part of the final query all the way to the actual source or database.

      In Designer, we exposed it as creating a "Source Function" which better describes it as a function that exists or is know by a database source.
      Show
      What is a 'pushdown' function? For standard Teiid Designer user-defined functions, the function "code" is deployed under Teiid, so the function get's executed during the Teiid Query result-set processing.The "pushdown function" relates to "pushing down" the SQL that contains the function call as part of the final query all the way to the actual source or database. In Designer, we exposed it as creating a "Source Function" which better describes it as a function that exists or is know by a database source.

      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.

        1. CreatePushdownFunctionDialog_draft.png
          42 kB
          Barry LaFond
        2. ProductsSQL.xmi
          10 kB
          Barry LaFond
        3. PushdownFunction.gif
          0.1 kB
          Barry LaFond
        4. PushdownFunction.gif
          0.1 kB
          Barry LaFond
        5. PushdownVDB.vdb
          2 kB
          Barry LaFond
        6. TEIIDDES-992_pushdownfunctions.patch
          81 kB
          Barry LaFond

              blafond Barry LaFond
              bgroh_jira Bernd Groh (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: