v.23.11New Feature
Add _size virtual column for file size in bytes to storage engines
Add_sizevirtual column with file size in bytes tos3/file/hdfs/url/azureBlobStorageengines. #57126 (Kruglov Pavel).
Why it matters
This feature allows users to easily retrieve the size of the underlying files directly from the table metadata without needing to query external storage or maintain separate tracking, improving convenience and transparency when working with external or file-based data sources.How to use it
When querying tables created with thes3, file, hdfs, url, or azureBlobStorage engines, simply include the _size column in your SELECT statement to get the size of each file in bytes, for example:SELECT _size, * FROM table_name