SQL like:
select columnName,count(*) from tableName group by columnName limit 10
offset 1
在 2015年12月25日 13:14, [email protected] 写道:
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]
