ClickHouse / ClickHouse/clickhouse-java
[Client, JDBC] Support Aggregate Functions
- Dominant language
- Java
- Stars
- 1.6k
- Forks
- 636
- Avg merge
- 2d 16h
- Merged PRs (30d)
- 28
Description
### Description
There is currently only SimpleAggregate function columns are supported and partially.
Related to https://github.com/dbeaver/dbeaver/issues/29931
Example table:
```SQL
CREATE TABLE signoz_metrics.exp_hist
(
`env` LowCardinality(String) DEFAULT 'default',
`temporality` LowCardinality(String) DEFAULT 'Unspecified',
`metric_name` LowCardinality(String),
`fingerprint` UInt64 CODEC(Delta(8), ZSTD(1)),
`unix_milli` Int64 CODEC(DoubleDelta, ZSTD(1)),
`count` UInt64 CODEC(ZSTD(1)),
`sum` Float64 CODEC(Gorilla, ZSTD(1)),
`min` Float64 CODEC(Gorilla, ZSTD(1)),
`max` Float64 CODEC(Gorilla, ZSTD(1)),
`sketch` AggregateFunction(quantilesDD(0.01, 0.5, 0.75, 0.9, 0.95, 0.99), UInt64) CODEC(ZSTD(1))
)
ENGINE = MergeTree
PARTITION BY toDate(unix_milli / 1000)
ORDER BY (env, temporality, metric_name, fingerprint, unix_milli)
TTL toDateTime(unix_milli / 1000) + toIntervalSecond(2592000)
SETTINGS ttl_only_drop_parts = 1,
index_granularity = 8192;
```
Contributor guide
Assessment
This issue has not been assessed yet.