horaedb icon indicating copy to clipboard operation
horaedb copied to clipboard

APPROX_PERCENTILE_CONT is not supported in distributed table

Open jiacai2050 opened this issue 2 years ago • 0 comments

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

jiacai2050 avatar Dec 26 '23 09:12 jiacai2050