Why does this fail (is it because of conflict with `interval` as result alias?)

[srikanthccv]

SELECT
    toStartOfInterval(timestamp, toIntervalMinute(1)) AS interval,
    column_name
FROM table
WHERE true
GROUP BY (interval, column_name)
ORDER BY (interval, column_name) ASC

It throws line 5:18 unexpected token kind: ,

[git-hulk]

@srikanthccv It should be caused by the interval being a keyword in ClickHouse, will fix this later. You could workaround this by changing to the following for now:

SELECT
    toStartOfInterval(timestamp, toIntervalMinute(1)) AS interval,
    column_name
FROM table
WHERE true
GROUP BY (`interval`, column_name)
ORDER BY (`interval`, column_name) ASC