v.25.6New Feature

Introduce a new virtual column, _disk_name

Official CH changelog text
Allow filtering parts selected for query by the disk they reside on by introducing a new virtual column, _disk_name. #80650 (tanner-bruce).
Introduces a new virtual column, _disk_name, that allows filtering parts based on the disk they reside on during query execution.

Why it matters

This feature enables users to selectively query data parts located on specific disks, improving control over data access and optimizing query performance by targeting disks of interest.

How to use it

Use the virtual column _disk_name in your WHERE clause or other filtering expressions to restrict queries to parts stored on particular disks. For example:

SELECT * FROM table WHERE _disk_name = 'disk_name_here'

Related resources

PreviousNext