[teiid-issues] [JBoss JIRA] (TEIID-669) Support "pass though" SQL commands to sources
[
https://issues.jboss.org/browse/TEIID-669?page=com.atlassian.jira.plugin....
]
Ramesh Reddy commented on TEIID-669:
------------------------------------
JLee, I thought the only changes we are going to do for EDS 5.3 was in the JBDS which are
going in their rollup. The extension properties for native query for relational sources is
already in the 5.3. These TEIID-2176, TEIID-2177 JIRAs expand the native query support to
other sources and also provide native procedure support which we are not approved for 5.3
Support "pass though" SQL commands to sources
---------------------------------------------
Key: TEIID-669
URL: https://issues.jboss.org/browse/TEIID-669
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 8.2
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira