From: | Matias Montroull <matimontg(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
Subject: | SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont |
Date: | 2021-09-24 13:23:13 |
Message-ID: | CAKKNfuLdEKZdH2V-6mhiidrq0TSHYWjSaCRNhTbz_uqxYZvBaQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I have a query like this:
*select date_trunc('minute',created) as
created,hostname,substring(datadir,0,15) as data_partition, query,sum(size)
as disk_usage*
*from gp_wf_per_query a*
*JOIN gp_segment_configuration c ON a.segid = c.content*
*where datadir like '%primary%'*
*group by query, hostname,
substring(datadir,0,15),date_trunc('minute',created)*
*order by date_trunc('minute',created) desc,hostname desc,
substring(datadir,0,15) asc;*
and I'm getting an error:
*SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate
percentile_cont*
Here's a create table statement and some sample data to reproduce the error:
CREATE TABLE initial (
created timestamp without time zone ,
hostname text ,
data_partition text ,
query text ,
disk_usage numeric
);
I attach some sample data to load the table
Attachment | Content-Type | Size |
---|---|---|
sample_data.sql | application/octet-stream | 1.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2021-09-24 21:04:17 | Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont |
Previous Message | Rob Sargent | 2021-09-20 16:58:03 | Re: How to sort deleted rows with trigger. Some rows before then some rows after. |