Make better use of partitions for simple queries
- Dominant language
- Java
- Stars
- 9.2k
- Forks
- 3.5k
- Avg merge
- 2d 11h
- Merged PRs (30d)
- 132
Description
### Feature Request / Improvement
Let's suppose you have a table partitioned on a column called `utc_date`. If a user runs a query to get something like:
```
select min(utc_date) FROM foo
```
It should be smart enough to recognize that this query doesn't need to actually scan any data, but rather just get the minimum partition with data available in it. It shouldn't take long to run, it should behind the scenes just get the minimum partition available.
### Query engine
Trino
### Willingness to contribute
- [ ] I can contribute this improvement/feature independently
- [x] I would be willing to contribute this improvement/feature with guidance from the Iceberg community
- [ ] I cannot contribute this improvement/feature at this time
Contributor guide
Assessment
This issue has not been assessed yet.