The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
5 views

What is the best way to move Objects from Pre-Prod to Prod Env

I have two different environment Production(new) and pre-production(existing), We have given cluster ready with GP Installed on new prod environment I want to know what is the best way to move ...
-1
votes
1answer
26 views

How to update values from bytea to varchar in Greenplum?

I need to convert hexa to values and need to update the values in a varchar field, I have tried: select pg_catalog.decode(column,'hex') The above code converted hexa to values but when I try to ...
1
vote
2answers
44 views

How to calculate the cumulative difference between rows in Postgres?

I am in need of calculating the difference from the cumulative values for the previous day in Postgres based on session_id. Example as mentioned below: Date session_id upload_usage ...
0
votes
0answers
14 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
87 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
19 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
69 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
160 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
197 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 ...