Find modal values in each row, with custom tie breaking in PostreSQL...

Postgresql COPY inside another COPY FROM PROGRAM fires error...

How to use a SQL window function to calculate a percentage of an aggregate...

Greenplum Database service running on docker consumes high disk space...

A subquery has set of 10 records with 5 columns , outer query has to create a column based on value ...

Greenplum gprestore - cannot find file (gpfmt_gpss.so)...

When greenplum gpss commit to kafka topic...

Shift operation grouping by a certain column SQL...

gp function cannot execute on segment because it issues a non-SELECT statement...

Greenplum Installation on centos 7...

postgresql: negative substring length not allowed but no obvious violation in data...

How to convert MySQL CONVERT_TZ() to Postgresql...

NOT EXISTS clause in Postgresql...

GPDB distribution key should be same order?...

How to put a scheduled task on GreenPlum?...

Informatica PowerCenter Greenplum Connector...

Appending postfix string to result of select query in Greenplum database...

From postgres to greenplum via pxf UUID and INET types aint' supported?...

SQL REGEXP_REPLACE() function...

Greenplum pxf - select from external table - invalid configuration...

Greenplum distribution...

Hive Migrate Date Format from Greenplum SQL...

SQL query conversion to Hive supported migration SQL...

Does order of the data in the table affect it's performance? RLE compression...

Hive Substring from complex subquery...

Postgres (Greenplum) disallow user role to create table as themselves...

Hive trunc date format issues...

How to use gpload utility?...

SQL error 42P01 when using jsonb_to_recordset function...

Is it possible to find out the number of items in a row by using window functions in PostgreSQL?...