v.23.7New Feature
Add any_value as compatibility alias for any aggregate function
Addany_valueas a compatibility alias foranyaggregate function. Closes #52140. #52147 (flynn).
Why it matters
This feature provides compatibility for users migrating from other SQL databases or tools that useany_value for getting an arbitrary value from a group, aligning ClickHouse's functionality with common SQL conventions and improving user experience.How to use it
Use theany_value aggregate function in your queries exactly as you would use the any function, for example:SELECT any_value(column_name) FROM table_name GROUP BY grouping_column