Stack Overflow
Stack Overflow

Questions tagged [greenplum]

Greenplum is the worlds first open-source massively parallel processing database based on PostgreSQL.It provides powerful and rapid analytics on petabyte scale data volumes. Uniquely geared toward big data analytics, Greenplum Database is powered by the world’s most advanced cost-based query optimizer delivering high analytical query performance on large data volumes.

Greenplum is a massively parallel processing database based on PostgreSQL and is designed for analytic data warehouses to manage, store and analyze terabytes to petabytes of data. Greenplum is developed by Pivotal.

797 questions
-1
votes
3 answers

How to perform GreenPlum 6.x Backup & Recovery

I am using GreenPlum 6.x and facing issues while performing backup and recovery. Does we have any tool to take the physical backup of whole cluster like pgbackrest for Postgres, further how can we purge the WAL of master and each segment as we can't…
Arslan Khalid
  • 11
  • 3
-1
votes
1 answer

Greenplum install on GKE

I am trying to install Greenplum on GKE using the directions here I make it to step 12: but my operator pod is failing because it cannot pull the secret: kubectl logs -l app=greenplum-operator -n…
tdensmore
  • 667
  • 1
  • 6
  • 19
-1
votes
1 answer

gpload throws exception with "ERROR: invalid byte sequence for encoding "UTF8": 0xe5b82e"

When I use gpload to dump some data into greenplum, it failed due to one error: "ERROR: invalid byte sequence for encoding "UTF8": 0xe5b82e". I did some search for it. My greenplum is 5.18.0, and "show client_encoding" showes "UTF8", and while I…
mik
  • 29
  • 3
-1
votes
2 answers

how to migrate oracle data to greenplum database

how to migrate Oracle data to the Greenplum database is there any way that we can migrate the data from Oracle to the Greenplum database, like a tool is there any tool available to migrate Oracle data to the Greenplum database like SSMA
younus
  • 412
  • 2
  • 10
  • 20
-1
votes
1 answer

How can I get each line of prosrc from pg_proc?

I'm new on PostgreSQL and have a question. I'd like to make whole code on prosrc of pg_proc like in Oracle's user_source. select prosrc from pg_proc where proname= 'function_name' prosrc is of type text, so I want get every single line with a for…
Ben
  • 45
  • 1
  • 1
  • 6
-1
votes
1 answer

Get missing months from date for each and every id

I have a table which contains, memberid and date. I want to display for each and every member get the missing months from date. Here is the input table and expected table. I have tried creating a temp table to generate series from min month to max…
chintuyadavsara
  • 1,509
  • 1
  • 12
  • 23
-1
votes
1 answer

How to find the number of rows in a table in greenplum without using count(*)

Select count(*) from table; It takes too much time to perform i want the number of rows in a table from any system table.
aastha
  • 11
  • 3
-1
votes
1 answer

Trying to run EXPLAIN ANALYZE with rollback

I am building a Java program that needs to automatically collect data on SQL statements before scheduling them. The program right now runs an EXPLAIN statement and parses the results. I need the time parameter, so I need to run with ANALYZE, but I…
firestreak
  • 377
  • 4
  • 17
-1
votes
1 answer

Java JDBC Postgres copyIn not recognizing end of line and padding double quotes

I am trying to load data from Oracle to Greenplum using Java. I store the result set as comma separated values in to byte array input stream and then load it using copy in. import java.sql.*; import au.com.bytecode.opencsv.CSVWriter; import…
CuriP
  • 83
  • 10
-1
votes
1 answer

Is Greenplum efficient for social network / instant messaging app?

We are developing an application for social network / instant messaging and we are using Postgres-XL in a high speed network including 2 nodes. We expect to have millions of transactions from different severs, simultaneously from users that every…
Hesam saeedi
  • 1
  • 1
-1
votes
1 answer

When I use multi-table greenplum bulk load in kettle, I report the following error：

When I use multi-table greenplum bulk load in kettle, I report the following error： ERROR: Segment reject limit reached. Aborting operation. Last error was: missing data for column "deviceid"
Galen
  • 5
  • 4
-1
votes
1 answer

Greenplum 4.3: Filling Missing values

I was trying a SQL using Greenplum Database 4.3.23.0 got a table which has data like ID ID2 Code Type_ID Status y_id Latest_flag 10 10001 205 7 P 114 Y 10 10001 205 7 P 116 NULL 10 10002 205 …
krux
  • 1
  • 1
-1
votes
1 answer

how to design greenplum database constructure

i am working on designing constructure in Greenplum database. we have many clinets which need to store data for them. there are two ways to design database constructure. we build one database and different schemas in this database for each…
xianwei meng
  • 1
-1
votes
1 answer

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

i got errors when i created the partition tables automatically via trigger which is created in advance. enviorment info: GP version :4.3.8.1 error: NOTICE: Found 2 data formatting errors (2 or more input rows). Rejected related input data. ERROR: …
John.Shieh
  • 3
  • 3
-1
votes
1 answer

why run the gpseginstall utility occured hostfile_exkeys is not accessible as user gpadmin?

The GreenPlum version is 4.3.8 when I run the gpseginstall utility to create the Greenplum system user (gpadmin) on all hosts and set the password for that user on all hosts occured a error. Several steps before installing gpseginstall are…
wanghao
  • 271
  • 1
  • 7
  • 21
1 2 3
…
53 54