apache / apache/iceberg

Make better use of partitions for simple queries

Open
#16,622 0 comments 0 reactions 0 assignees View on GitHub
improvement
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.