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 >
