kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 华梦真 <hmzma...@163.com>
Subject I encountered a problem while querying data with kylin's Restful Api
Date Fri, 30 Jun 2017 08:02:58 GMT
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/related (inline, None, 0 bytes)
View raw message