Error Query Was Cancelled Because Planning Time Exceeded 60 Seconds

[akikax]

Eveyone, a workaround for this issue is captured here:

Filtering by date field not working on 2.1.4

Since 2.1.4, I’m unable to filter on a date field on an aggregated reflection whose a field is a date field. The filter criterium is basic, date_field >= ‘2018-01-01’ I get an Invalid Query error. I tried many tricks (casting to date, etc…) without success. Here is the query profile : 7fc75e23-fe28-4b9f-be49-4946d75f6e7d.zip (642.2 KB)

Essentially, go to Admin > Advanced Settings and set the following support key planner.experimental.pclean_logical to false