Postgres Pro
Downloads
Home   >   mailing lists

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

From Matias Montroull
Subject SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont
Date
Msg-id CAKKNfuLdEKZdH2V-6mhiidrq0TSHYWjSaCRNhTbz_uqxYZvBaQ@mail.gmail.com
Whole thread Raw
Responses Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: How to sort deleted rows with trigger. Some rows before then some rows after.
Next
From: "David G. Johnston"
Date:
Subject: Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont