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
