v.21.7Improvement

Enable Reading of Subcolumns for Distributed Tables

Enable reading of subcolumns (e.g. components of Tuples) for distributed tables. #24472 (Anton Popov).
Enable reading of subcolumns (e.g., components of Tuples) from distributed tables in ClickHouse.

Why it matters

This feature addresses the limitation in distributed tables where accessing specific components of tuple columns (subcolumns) was not supported. It allows users to efficiently select and query individual parts of complex tuple columns remotely, improving flexibility and reducing data transfer.

How to use it

Users can directly reference tuple components in their SELECT queries on distributed tables using the standard tuple syntax, for example: SELECT tuple_column.1 FROM distributed_table. No special configuration is needed to enable this functionality.