[teiid-issues] [JBoss JIRA] (TEIID-3482) Multi-source joins should still be partitioned even if not fully pushed

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3482:
---------------------------------------

I wanted to log this, but it likely won't get worked as we can't really do this unless we also project the source name column through all parts of the plan  For consistency the resolution here will likely be to turn the implicit option off and require the modeling to explicitly specify the partitioning predicates.  We can also introduce an explicit multi-tenancy mode such that a given user will only have access to a specific source or sources (this can be accomplished with row based conditions, but may benefit from something simpler in the context of multi-source). 

> Multi-source joins should still be partitioned even if not fully pushed
> -----------------------------------------------------------------------
>
>                 Key: TEIID-3482
>                 URL: https://issues.jboss.org/browse/TEIID-3482
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> A deficiency in join planning with multi-source is that partitioning only occurs if the join is pushed.  If not pushed then we'll union the results and process a join across all of the results.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)