v.21.7Improvement

Added Interval Support for LowCardinality Type

Added support Interval type for LowCardinality. It is needed for intermediate values of some expressions. Closes #21730. #25410 (Vladimir).
Added support for the Interval data type within the LowCardinality column type.

Why it matters

This feature addresses the need to use Interval type values as intermediate results in expressions while benefiting from the LowCardinality optimization. It improves performance and storage efficiency when working with interval data in low cardinality contexts.

How to use it

Users can now declare columns with the LowCardinality(Interval(...)) type in their table schemas or cast expressions accordingly, enabling optimized handling of interval values. No additional configuration is required.