[ 
https://issues.apache.org/jira/browse/KYLIN-207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14555800#comment-14555800
 ] 

liyang commented on KYLIN-207:
------------------------------

According to 
https://github.com/apache/incubator-calcite/blob/master/doc/reference.md

Kylin support "offset X row fetch first Y row only"

E.g. select summary_date, count(*) from test_kylin_fact group by summary_date 
order by 1 offset 0 row fetch first 10 row only

> Support SQL pagination
> ----------------------
>
>                 Key: KYLIN-207
>                 URL: https://issues.apache.org/jira/browse/KYLIN-207
>             Project: Kylin
>          Issue Type: Improvement
>          Components: Query Engine
>            Reporter: Luke Han
>            Assignee: liyang
>              Labels: github-import
>             Fix For: v0.7.2
>
>
> Support pagination in SQL query with "OFFSET" and "LIMIT"
> ---------------- Imported from GitHub ----------------
> Url: https://github.com/KylinOLAP/Kylin/issues/298
> Created by: [lukehan|https://github.com/lukehan]
> Labels: newfeature, 
> Milestone: Backlog
> Created at: Fri Dec 26 14:41:30 CST 2014
> State: open



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to