Query over Rest API results in bad query

[Aditya Rohilla]

Hey,



I am trying to send this query :



{ "sql": "select process, avg(w) as `avg_w`, sum(vol) as `sum_vol` from
WHY_XYZ where id in ('BLA') and balance_date between '2020-03-06' and
'2020-09-06' group by process order by process asc, "offset": 0, "limit":
1000, "acceptPartial": false, "project": null }



And it results in bad query as shown in the logs:



2020-10-15T22:29:37,092 INFO [BadQueryDetector]
org.apache.kylin.rest.service.BadQueryDetector - Detect bad query.


Any idea how I should send the sql query?

I am using mysql as sqldialect.



Thanks and Regards,

Aditya Rohilla