SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont

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

Responses

Browse pgsql-sql by date

  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.