v.1.1.54362New Feature

Added cluster table function with remote table compatibility

Added the cluster table function. Example: cluster(cluster_name, db, table). The remote table function can accept the cluster name as the first argument, if it is specified as an identifier.
Added the cluster table function to ClickHouse, allowing users to easily reference tables across clusters.

Why it matters

This feature simplifies querying distributed data by enabling users to target a cluster directly via the cluster table function. It resolves the complexity of accessing tables in cluster setups by providing a straightforward way to specify the cluster name along with database and table names.

How to use it

Use the new cluster table function in the format cluster(cluster_name, db, table) to query a table on a specific cluster. Additionally, the existing remote table function now supports specifying the cluster name as its first argument when passed as an identifier.