horaedb
horaedb copied to clipboard
APPROX_PERCENTILE_CONT is not supported in distributed table
Describe this problem
Query contains APPROX_PERCENTILE_CONT function will throw errors.
Server version
main
Steps to reproduce
CREATE TABLE `demo` (
`name` string TAG,
`value` double NOT NULL,
`t` timestamp NOT NULL,
timestamp KEY (t))
PARTITION BY RANDOM PARTITIONS 4
ENGINE=Analytic
with
(enable_ttl="false");
INSERT INTO demo (t, name, value)
VALUES (1651737067000, "ceresdb", 100)
,(1651737067000, "ceresdb1", 110)
,(1651737067000, "ceresdb2", 120);
;
analyze select time_bucket(t, "PT1M") as a, approx_percentile_cont(value, 0.9) as b from demo
where name = "ceresdb"
and t >= 1651737067000
group by time_bucket(t, "PT1M")
;
Expected behavior
No error.
Additional Information
No response