[
https://issues.jboss.org/browse/TEIID-1726?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1726:
---------------------------------------
Here's what I'm working towards:
The initial implementation will be a multi-hint container hint of the form
"sh(:'arg')? translator-name:'arg' ...", where the hint args
follow the parsing rules for string literals. For example:
select /*+ sh:'foo' oracle:'all_rows' */ x, y ...
Since we are already breaking encapsulation, there is no direct support for referencing
Teiid columns/tables. It is expected that the user will know the appropriate block name
and or source names that their hint affects. If a user wishes they can expand on this
technique to include fully qualified Teiid names in the hint and then use the runtime
metadata facility to lookup appropriate source metadata (and they would also potentially
need the appropriate correlation name). Note that we could leave off the notion of a
general hint for now, but it seems useful to have a single place to specify a hint that
can be passed to all sources.
The translators will receive the source hint (both the general sh argument if specified
and the translator specific if available) from the top most level query providing a hint.
New methods may be needed on the ExecutionContext to support this. Hints from a subquery,
or joined/unioned view will be ignored.
Only the oracle translator will do anything with these hints to begin with. If a hint is
specified, then it will be placed in the source query surrounded by /*+ */.
These source hints will be expected to appear after the first token in the query and can
appear on user queries, view definitions, or in virtual procedure command statements (a
minor amount of additional effort would also allow them to appear in arbitrary virtual
procedure expressions).
Also available in 7.6 is support for native-query metadata on source tables/procedures -
see TEIID-669 and the reference.
Let me know if you have any concerns.
Requesting ability to add/use Oracle hints in EDS
-------------------------------------------------
Key: TEIID-1726
URL:
https://issues.jboss.org/browse/TEIID-1726
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.4.1
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Fix For: 7.6
Requesting the ability to use Oracle hints inside virtual transformations and enduser
queries in EDS and Teiid Designer
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira