[teiid-issues] [JBoss JIRA] (TEIID-2558) Add translator support for dependent join pushdown

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2558:
---------------------------------------

I'll likely split this into several pieces.  The first is to just deliver the key dependent join pushdown functionality for a major source such as Oracle with generalizations that should help support the other JDBC translators.  From there the full dependent join pushdown and other sources can be treated as separate issues.

In looking at the options we may want a hint to know if the independent set is distinct and or if it should be made distinct prior to pushdown.  For now it has been left as the raw feed from the join.

Looked at using oracle array types to more effectively bind large number of values using "col in (select * from TABLE(cast(? as somearray)))"  where somearray is a varray type that can accommodate the values - however that seemingly had poor performance at least against 10g for relatively small arrays.  So will proceed with a temp table approach.


                
> Add translator support for dependent join pushdown
> --------------------------------------------------
>
>                 Key: TEIID-2558
>                 URL: https://issues.jboss.org/browse/TEIID-2558
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Connector API
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> JDBC translators should offer built-in support for dependent join pushdown - possibly with index creation and other options.

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