I was attempting to upgrade clickhouse from version 23.1 to either 23.2 or 23.3 but all aggregation queries are failing. select * works. Rolled back and it works fine. below is a result of doing a select count() from table..

:Exception: Not found column count() in block. There are only columns: . (NOT_FOUND_COLUMN_IN_BLOCK)