v.22.1upgrade-notes
Functions 'left' and 'right' in ClickHouse: Upgrade Notice and Exception Handling
The functionsleftandrightwere previously implemented in parser and now full-featured. Distributed queries withleftorrightfunctions without aliases may throw exception if cluster contains different versions of clickhouse-server. If you are upgrading your cluster and encounter this error, you should finish upgrading your cluster to ensure all nodes have the same version. Also you can add aliases (AS something) to the columns in your queries to avoid this issue. #33407 (alexey-milovidov).