[teiid-issues] [JBoss JIRA] (TEIID-1880) Support UNION ALL in multi source models
[
https://issues.jboss.org/browse/TEIID-1880?page=com.atlassian.jira.plugin...
]
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