[
https://issues.apache.org/jira/browse/CALCITE-1886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16083880#comment-16083880
]
yuqi commented on CALCITE-1886:
-------------------------------
Calcite has already support this grammar, as far as a i know
for example the sql:
{code:java}
INSERT into db_sink SELECT id,name,price + 1 as price FROM kafka_source limit
100 offset 10
{code}
can be translated as
{code:java}
'LogicalTableModify(table=[[DB_SINK]], operation=[INSERT], flattened=[true])
LogicalSort(offset=[10], fetch=[100])
LogicalProject(ID=[$0], NAME=[$1], PRICE=[+($2, 1)])
EnumerableTableScan(table=[[KAFKA_SOURCE]])
{code}
> Support LIMIT [offset,] row_count
> ---------------------------------
>
> Key: CALCITE-1886
> URL: https://issues.apache.org/jira/browse/CALCITE-1886
> Project: Calcite
> Issue Type: Improvement
> Reporter: Chen Xin Yu
> Assignee: Julian Hyde
>
> CALCITE support limit offset SQL grammar in CALCITE-43 :
> [LIMIT { count | ALL}]
> [OFFSET start { ROW | ROWS}]
> LIMIT {[offset,] row_count} is also popular used, especially in MySQL, such
> as:
> select * from tableA order by id limit 100,10;
> User should transform the existing sqls until calcite support LIMIT
> {[offset,] row_count}.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
