jayshrivastava commented on issue #25483:
URL: https://github.com/apache/datafusion/issues/25483#issuecomment-5735805577
Just adding a couple examples where I think this change will help.
Aggregations
```sql
SELECT day, count(log)
FROM logs.range_partitioned_data_on_day_hour
GROUP by day
```
Map N partitions on `day, hour` to M partitions partitioned by day where M <
N, requiring fewer than N * M relationships.
Partitioned Joins
```sql
SELECT *
FROM logs.range_partitioned_data_on_day_hour AS logs
JOIN logs.range_partitioned_data_on_day_only AS daily_logs
ON daily_logs.day = logs.day
```
We would be able to repartition the `day, hour` partition data to be
partitioned on `day` only and perform a partition join with data that is
partitioned by `day`.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
