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, 华梦真 <[email protected]> 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. > > > > > > >
