The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
7 views

Risk associated with “master catalog has become out of sync with the warm standby master”

Am I correct to suspect that when a Greenplum system's master servers have entered a state of "master catalog has become out of sync with the warm standby master", we are then running in a state with ...
0
votes
0answers
69 views

Greenplum's poor dynamic partition elimination

I have large fact tables in Greenplum with many years of history that are partitioned by a surrogate key (which represents time). Of course almost all queries are for recent time periods where the ...
1
vote
0answers
18 views

Word frequency query in Greenplum [closed]

What is the query for word frequency and word count, word occurance and pattern search in Greenplum?
0
votes
0answers
57 views

Unable to exit a Greenplum SQL script

Is there any way in psql (Greenplum flavour) of exiting a script? I have tried with \q and \quit, e.g. \echo "Hello"; \q -- or \quit but I get: my_database> \i my_script.sql ...
1
vote
0answers
125 views

Move data from a Greenplum database to Oracle

my company is migrating its Data Warehouse from Oracle to Greenplum. The migration is gonna be progressive, that is they will migrate the ODS first and at a later stage the DDS as well. I would like ...
1
vote
0answers
170 views

How to make Greenplum 4.2.3 only scan the intended partition?

When I uses unnest() in a View, and uses that View in a select statement, Greenplum seems to fail in only searching for the intended partition and search through all the partition of the main table ...