[teiid-issues] [JBoss JIRA] Commented: (TEIID-1533) additional controls for dependent joins

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-1533:
---------------------------------------

also added splitting of in predicates based upon the max in size using a new capability maxDependentInPredicates.  Defaults were assigned base upon best guesses given the allowable sql length.  This will not fully restrict the number of predicates in all situations.  If there is join involving related dependent conditions (coming from the same source), it is possible that the number of generate predicates could be slightly larger than the max.  If/when we add support for array value type comparisons, this will not be an issue.

> additional controls for dependent joins
> ---------------------------------------
>
>                 Key: TEIID-1533
>                 URL: https://issues.jboss.org/browse/TEIID-1533
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Connector API
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.4
>
>
> We should add back the ability for the user to set the max in size on all translators and also determine a cutoff value for cost based dependent joins after which the dependent join will not be performed if the independent side has too many distinct values.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira