v.23.8Improvement

Support for Reading Tuple Subcolumns from Various Storage Systems

Support reading tuple subcolumns from file/s3/hdfs/url/azureBlobStorage table functions. #51806 (Kruglov Pavel).
Support reading tuple subcolumns from file, s3, hdfs, url, and azureBlobStorage table functions.

Why it matters

This feature enables users to directly access and read specific elements within tuple columns from various external data sources using table functions. It simplifies data extraction and improves flexibility when working with nested tuple data stored in external files or cloud storage.

How to use it

When querying data via the supported table functions (file, s3, hdfs, url, azureBlobStorage), specify tuple subcolumns in the SELECT clause or in projections to read nested elements directly within tuples.