[teiid-issues] [JBoss JIRA] (TEIID-1880) Support UNION ALL in multi source models

[Tim Bruce (Commented) (JIRA)]

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

Tim Bruce commented on TEIID-1880:
----------------------------------

The actual problem we are seeing is that we are not getting the LIMIT and ORDER BY information in our translator for any user queries.  For example, an SQL query with no other clauses other than simple WHERE and LIMIT clauses (in a multi-source model configuration) is sent to each translator with the WHERE information but not the LIMIT information.
                
> Support UNION ALL in multi source models
> ----------------------------------------
>
>                 Key: TEIID-1880
>                 URL: https://issues.jboss.org/browse/TEIID-1880
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>
> We have physical data sources that can have many millions of rows.  We are currently using Teiid's multi-source feature to union them together but, I believe Teiid is doing a proper UNION of the tables as opposed to a UNION ALL.  The implied distinct operation in the UNION slows down our queries a lot because many operations cannot be pushed down to the underlying data sources and must be resolved in Teiid.
> We would like the option of performing a UNION ALL on multi source models

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira