[teiid-issues] [JBoss JIRA] (TEIID-3957) Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause
Steven Hawkins (JIRA)
issues at jboss.org
Fri Jun 3 18:44:02 EDT 2016
[ https://issues.jboss.org/browse/TEIID-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-3957.
---------------------------------
> Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-3957
> URL: https://issues.jboss.org/browse/TEIID-3957
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Affects Versions: 8.12.4
> Environment: Ubuntu Trusty
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 9.0
>
>
> With the impala translator we issue this LIMIT to Teiid:
> ORDER BY somecolumn DESC LIMIT 75, 25
> this means give me 25 rows starting from *ROW* 76.
> In Impala's SQL this should be translated to:
> ORDER BY somecolumn DESC LIMIT 25 OFFSET 75
> BUT this means give me 25 rows starting from *PAGE * 76 (with page size of 25 rows)
> ref: http://www.cloudera.com/documentation/archive/impala/2-x/2-1-x/topics/impala_offset.html
> The Teiid Impala translator doesn't push the offset but sums the limit and offset:
> ORDER BY somecolumn DESC LIMIT 100
> Request we add pushdown, which will be more efficient and overcome the difference in how offsets are handled between Impala and Teiid.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list