Hello,
What kind of exception/error did you met ? Could you please share with us
some more log?
Actually, "org.apache.kylin.rest.service.BadQueryDetector - Detect bad
query." did not provided enough information for cause analysis.
--
Best wishes to you !
From ：Xiaoxiang Yu
At 2020-10-17 22:45:34, "Aditya Rohilla" <aditya.rohill...@gmail.com> wrote:
>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
