[teiid-issues] [JBoss JIRA] (TEIID-2381) Expanded source hint support

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12752651#comment-12752651 ] 

Steven Hawkins commented on TEIID-2381:
---------------------------------------

Considerations for this issue include:
* expanded placement of the hint in the user query (parser changes)
* alternatively or additionally whether some sort of global hint syntax, rather than just source name, would be a better approach to indicate where a source hint is applicable.
* additional placements of the hint in the source sql (would require translator/design changes).  For example to be able to push multiple hints in multiple query locations in the same pushdown query, such as one in the SELECT and one in a WITH clause/subquery.
* general definition of how multiple hints interact at different levels (in views which is currently mostly ignored)/placements in the user query.

                
> Expanded source hint support
> ----------------------------
>
>                 Key: TEIID-2381
>                 URL: https://issues.jboss.org/browse/TEIID-2381
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>
> We currently look at the source hint in only the root user query (not in subqueries nor the with clause) and only consider it in a very narrow set of circumstances when it's used in a view.

--
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