[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=12789441#comment-12789441 ] 

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

The array method above is reasonably performant when a cardinality hint is added, but it is a somewhat limiting approach.  The full array must be held in memory (which may be reasonable for even joins with millions of rows that use a single/simple join column) and any single number/string join would require the creation of an appropriate array/struct type to hold the key data.

One possible approach would be to assume that appropriate global temporary tables have already been created possibly by us at deployment type - but given the possible type combinations and possible multiple appearances of dependent sets in a given source query that seems unpalatable.
                
> 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