I'm a new user of Metabase, not an admin. trying to do common table expression to group by working hours not calendar. but it keeps showing the following error message no idea why. would appreciate some help. here is an example.
MySQL is sadly really terrible at reporting the specific error.
But it looks like you highlighted parts of the query and then ran only that.
same error whole query or only CTE part. don't know what's wrong. I have validated the query on syntax check and looks fine. it's really frustrating. followed Metabase documentation for CTE still the same error.
correct. I found out Mysql version used is 5.7 not 8. CTE only supported by version 8.
do you know a way to group by working hours not calendar on metabse