I created a ticket to enhance this to make sure sure not confused. https://issues.apache.org/jira/browse/KYLIN-1253
On Fri, Dec 25, 2015 at 1:37 PM, Jian Zhong <[email protected]> wrote: > when trying to run 'offset' in sql,we should make sure 'LIMIT' not used in > post body > > so, just set the 'LIMIT' input box near the 'SUBMIT' button to '0',you > will get right results. > > On Fri, Dec 25, 2015 at 1:14 PM, [email protected] < > [email protected]> wrote: > >> I haven't use restful api ,instead I use jdbc >> At first, I use Kylin Web, at Query tab, I input my sql as "select * >> from tableName limit 10, 10", The error is >> "Encountered ',' at line ……. Was expecting one of:<EOF>'OFFSET'... >> 'FETCH'..." >> So I change my sql as "select * from tableName offset 10 rows fetch next >> 10 rows only" ,But also reporting error, The error is >> "Encountered 'LIMIT' at line…… Was expecting:<EOF>" >> But when I test it in jdbc, I find it runs well. >> >> Thanks and merry christmas! >> >> >> [email protected] >> >> From: hongbin ma >> Date: 2015-12-24 23:01 >> To: dev >> Subject: Re: kylin how to realize pagination >> @jason I don't think wangshifa is not looking for what you provided. >> @wangshifa, can you please provide the failed query that you tried, so >> that >> we can try and debug >> >> On Thu, Dec 24, 2015 at 2:55 PM, Jian Zhong <[email protected]> >> wrote: >> >> > try like this >> > >> > http://hostname:7070/kylin/api/cubes?limit=10&offset=0 >> > >> > On Thu, Dec 24, 2015 at 1:23 PM, [email protected] < >> > [email protected]> wrote: >> > >> > > Anyone can tell me how kylin can realize pagination? >> > > I use "limit" and "offset fetch" but don't work. >> > > >> > > >> > > >> > > [email protected] >> > > >> > >> >> >> -- >> Regards, >> >> *Bin Mahone | 马洪宾* >> Apache Kylin: http://kylin.io >> Github: https://github.com/binmahone >> > >
