kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: I encountered a problem while querying data with kylin's Restful Api
Date Tue, 11 Jul 2017 03:44:57 GMT
The date constants should lead by a 'date' keyword, like date '2012-08-01'.

For example, the above query should rewrite as:
select sum(a.price), a.PART_DT from KYLIN_SALES a where a.PART_DT< *date
'2012-08-01'* group by a.PART_DT

On Fri, Jun 30, 2017 at 4:02 PM, 华梦真 <hmzmandy@163.com> wrote:

> Hi ,
>     I used kylin's Restful Api like below:
>
> curl -X POST --user ADMIN:KYLIN  -H "Content-Type:
> application/json;charset=utf-8" -d '{ "sql":"select sum(a.
> price),a.PART_DT,a.seller_country,a.seller_id from
> KYLIN_SALES  a inner join KYLIN_COUNTRY  b on a.seller_
> country = b.country where a.PART_DT< '2012-08-01'  group
> by a.PART_DT,a.seller_country,a.seller_id  limit 2 ","
> project":"test_01" }' http://172.16.71.220:7070/kylin/api/query
>
>
> Then i got an error like this:
> {"url":"http://172.16.71.220:7070/kylin/api/query","
> exception":"Error while executing SQL \"select sum(a.
> price),a.PART_DT,a.seller_country,a.seller_id from
> KYLIN_SALES  a inner join KYLIN_COUNTRY  b on a.seller_
> country = b.country where a.PART_DT< 2012-08-01  group by
> a.PART_DT,a.seller_country,a.seller_id  limit 2\": From
> line 1, column 147 to line 1, column 167: Cannot apply '<'
> to arguments of type '<DATE> < <INTEGER>'. Supported form(s)
> : '<COMPARABLE_TYPE> < <COMPARABLE_TYPE>'"}
>
>
> Then i tried to solve the problem:
> curl -X POST --user ADMIN:KYLIN  -H "Content-Type:
> application/json;charset=utf-8" -d '{ "sql":"select sum(a.
> price),a.PART_DT,a.seller_country,a.seller_id from
> KYLIN_SALES  a inner join KYLIN_COUNTRY  b on a.seller_
> country = b.country where a.PART_DT< \'2012-08-01\'  group by a.
> PART_DT,a.seller_country,a.seller_id  limit 2 ","project":"test_01" }'
> http://172.16.71.220:7070/kylin/api/query
> However,I still failed.There was no response,and the log had nothing about
> it.
>
> It seemed that  single quotation marks can not be recognized.And I have no
> idea to solve this problem.
>
> Look forward to your reply.Thanks.
>
>
>
>
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message