v.19.5Improvement

Buffer Table Engine Now Supports PREWHERE

Official CH changelog text
Buffer table engine now supports PREWHERE. #4671 (Yangkuan Liu)
The Buffer table engine now supports the use of the PREWHERE clause in queries.

Why it matters

This feature enables more efficient data filtering before full query execution when using the Buffer engine, improving query performance by reducing the volume of data processed.

How to use it

Users can write queries on Buffer tables including the PREWHERE clause just like with other table engines, to pre-filter data early in the query pipeline.

Related resources

PreviousNext