Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-669

Support "pass though" SQL commands to sources

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 8.2
    • None
    • Query Engine
    • None

    Description

      Currently there is no mechanism in Teiid, when a query is submitted to a runtime engine that is passed through the query engine unadulterated and unmodified and submitted directly to a source connector. All queries are parsed, optimized, re-written. Some times this limits the functionality in Teiid, when a user would like to execute a query that is very "source" specific. For example Oracle supports lots of Oracle specific functions that are not supported by the SQL spec, to support execution of these in Teiid user need to resort to UDF, which is cumbersome and involves modelling.

      Another benefit of this is also to pass DDL to sources, currently since Teiid does not support DDL, this is not possible at all.

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-rareddy Ramesh Reddy
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: