Yes, if we do not use sql like "SELECT ... OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY"
the easy way is syntax as xiaoyu said "SELECT.... limit 10 offset 10" On Fri, Dec 25, 2015 at 1:41 PM, Jian Zhong <[email protected]> wrote: > 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 >>> >> >> >
