uwheel/datafusion-uwheel

Support Temporal Projection Filtering

Closed this issue · 1 comments

SELECT * FROM yellow_tripdata 
WHERE tpep_dropoff_datetime >= '{}' 
AND tpep_dropoff_datetime < '{}'

The following query can use the underlying Count wheel to check whether there are any entries for the range, skipping execution if there aren't any.

Screenshot 2024-07-26 at 10 58 07

This optimization shows the most improvement when dealing with fine-grained time ranges at second granularity.