[teiid-issues] [JBoss JIRA] Updated: (TEIID-152) New SQL directive OPTION NOJOINPUSHDOWN that tells query planner to not push down any joins

[Ramesh Reddy (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy updated TEIID-152:
-------------------------------

          Component/s: Query Engine
        Fix Version/s: 6.x
    Affects Version/s: 6.x


> New SQL directive OPTION NOJOINPUSHDOWN that tells query planner to not push down any joins
> -------------------------------------------------------------------------------------------
>
>                 Key: TEIID-152
>                 URL: https://jira.jboss.org/jira/browse/TEIID-152
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 6.x
>            Reporter: Greg Haber
>            Priority: Minor
>             Fix For: 6.x
>
>
> This capability has been requested by a customer(see I-T ticket 217562).  They want us to add in the following functionality:
> -add an OPTION directive (OPTION NOJOINPUSHDOWN) to MetaMatrix SQL that tells the query planner whether or not to attempt to push down joins for a particular query.  This would be a general purpose MetaMatrix SQL change.  The default would be for our query planner to act as it does today (do join pushdown as allowed by connector capabilities), and the behavior if this OPTION directive was used would be to instead not do any join pushdown for any part of the user query, even if allowed by connector capabilities.
> What this would allow them to do, if JBEDSP-348 is also implemented, is to leverage the limited join capability that SFDC has via its "relationship query" functionality.  Because SFDC doesn't have full join capabilities, this would allow them to first try to submit a query against a VDB that uses SFDC as a source and see if the part of the join that the query planner pushes down to SFDC is something that SFDC can actually do.  If not, the SFDC connector would throw an error, and the customer would resubmit their query with this OPTION NOJOINPUSHDOWN option.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira