Hi,
Kylin can support paged query? This sql can't work
select * from KYLIN_SALES OFFSET 100 ROWS FETCH FIRST 10 ROWS
Calcite doc:
query:
values | WITH withItem [ , withItem ]* query | { select | selectWithoutFrom |
query UNION [ ALL | DISTINCT ] query | query EXCEPT [ ALL | DISTINCT ] query |
query MINUS [ ALL | DISTINCT ] query | query INTERSECT [ ALL | DISTINCT ] query
} [ ORDER BY orderItem [, orderItem ]* ] [ LIMIT { count | ALL } ] [ OFFSET
start { ROW | ROWS } ] [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ]
[email protected]
