ClickHouse / ClickHouse/ClickHouse

Minmax data skipping index impact on min and max functions

Open
#54,510 2 comments 1 reaction 0 assignees View on GitHub
comp-skip-index external feature
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

It seems like the minmax index should affect min() and max() functions perfomance of the select queries without grouping if a server compares only min/max values of granule groups.

Sql example:
```Sql
create table measurements (
...
timestamp UInt64,

index idx_timestamp timestamp type minmax
)
...
```
```Sql
select max(timestamp) from measurements
```

It now executes full column scan (server version 23.3.8.21).

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.