support quantilesDD

[tuyula]

Is your feature request related to a problem? Please describe.
org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error: java.lang.IllegalArgumentException: Unknown aggregate function: quantilesDD

[E1izabeth]

Please provide driver and server version. You can get this information by clicking Test connection... button in the Connection configuration dialog.

[E1izabeth]

Also please provide example of query to reproduce this issue.

[E1izabeth]

Besides that, it's not clear why do you created this feature request in DBeaver, but not in Clickhouse driver repository. Could you explain?

[tuyula]

first i have table which ddl is

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; 

[tuyula]

then i click the table by dbwaver

and my driver is

[E1izabeth]

Thank you for details.

[E1izabeth]

I reproduced the issue. It works fine with just quantiles instead of quantilesDD. I don't think it's a DBeaver issue.