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

Поиск
Список
Период
Сортировка
От Matias Montroull
Тема SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont
Дата
Msg-id CAKKNfuLdEKZdH2V-6mhiidrq0TSHYWjSaCRNhTbz_uqxYZvBaQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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
Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: How to sort deleted rows with trigger. Some rows before then some rows after.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont