Does kylin support date/time functions like TIMESTAMPADD、TIMESTAMPDIFF?

2016-08-30 Thread wangsh...@sinoaudit.cn
Does kylin support date/time functions like TIMESTAMPADD、TIMESTAMPDIFF? 
I saw calcite support these,   but when I use TIMESTAMPADD function in kylin 
web client, it says no match found for function signature ...



wangsh...@sinoaudit.cn


Re: Re: about the parameter 'acceptPartial'

2016-01-05 Thread wangsh...@sinoaudit.cn
Yes, how can I do? 



wangsh...@sinoaudit.cn
 
From: Li Yang
Date: 2016-01-05 17:29
To: dev
Subject: Re: about the parameter 'acceptPartial'
You want it be "false" always.
 
When "true", Kylin may choose to return incorrect partial result as purpose
of preview.
 
On Mon, Jan 4, 2016 at 6:16 PM, wangsh...@sinoaudit.cn <
wangsh...@sinoaudit.cn> wrote:
 
> Hi all:
>  Can anybody tell me what the query parameter 'acceptPartial' means? and I
> wonder how I can setup this parameter in jdbc.
>
>
>
> wangsh...@sinoaudit.cn
>


about the parameter 'acceptPartial'

2016-01-04 Thread wangsh...@sinoaudit.cn
Hi all:
 Can anybody tell me what the query parameter 'acceptPartial' means? and I 
wonder how I can setup this parameter in jdbc.



wangsh...@sinoaudit.cn


Re: Re: kylin how to realize pagination

2015-12-24 Thread wangsh...@sinoaudit.cn
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:'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:"
But when I test it in jdbc, I find it runs well.

Thanks and merry christmas!


wangsh...@sinoaudit.cn
 
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  wrote:
 
> try like this
>
> http://hostname:7070/kylin/api/cubes?limit=10&offset=0
>
> On Thu, Dec 24, 2015 at 1:23 PM, wangsh...@sinoaudit.cn <
> wangsh...@sinoaudit.cn> wrote:
>
> > Anyone can tell me how  kylin can realize pagination?
> > I use "limit" and "offset fetch" but don't work.
> >
> >
> >
> > wangsh...@sinoaudit.cn
> >
>
 
 
-- 
Regards,
 
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone


kylin how to realize pagination

2015-12-23 Thread wangsh...@sinoaudit.cn
Anyone can tell me how  kylin can realize pagination?
I use "limit" and "offset fetch" but don't work.



wangsh...@sinoaudit.cn