_file and _path virtual columns made LowCardinality for faster queries in file-like table engines
Official CH changelog text
_file and _path virtual columns (in file-like table engines) are made LowCardinality - it will make queries for multiple files faster. Closes #34300. #34317 (flynn).