Details
-
Enhancement
-
Resolution: Done
-
Minor
-
8.12.4
-
None
Description
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.