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

Allow the use of pushdown functions without requiring Java programming

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • 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.

    Description

      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.

      Attachments

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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: