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
0
votes
0 answers

Greenplum loader issue with Informatica CDC

We use Informatica CDC to capture change data (near real time) from ERP source system. Our target is Greenplum DB. At Informatica session we use GP loader to load into target. Problem: As we fetch Near Real Time(NRT) data from ERP, we receive…
user3459079
  • 11
  • 7
0
votes
2 answers

cannot start greenplum - gpstart failed

I was trying to update to the latest java on my greenplum machine and changed the path variable to the latest java folder. Since then I have not been able to start the greenplumdb. Whenever i run the gpstart command .. i get the following…
user2912902
  • 327
  • 1
  • 7
  • 17
0
votes
1 answer

how to create custom function to analyze tables in postgres

I'm trying to set up an function that analyzes tables on the weekends. create or replace function public.sp_analyze(t text) returns void as $$ BEGIN if to_char(current_Date,'dy') = 'fri' THEN --RAISE NOTICE '%', t; execute 'vacuum…
suhprano
  • 1,723
  • 1
  • 16
  • 22
0
votes
2 answers

How to improve performance of Liquibase on Greenplum database

I'm evaluating the use of Liquibase (3.3.2) against a Greenplum (Postgres on steroids) database using postgresql 8.4-701.jdbc4 and am running into performance issues when trying to add one changeset (create table) against an existing schema…
bruce szalwinski
  • 724
  • 1
  • 8
  • 27
0
votes
2 answers

How to install greenplum

I am trying to install greenplum. I was trying to do it in ubuntu vm. But I am not getting proper links to install it. Can anyone help me in installing greenplum?
Ankita Barbie
  • 5
  • 1
0
votes
2 answers

Rollback data of a table deleted in Greenplum

I am using Greenplum DB 4.3 version, A table which have meta data information for my application and it is deleted wrongly, Is there any way to roll back a table which was deleted by mistake ??
Krip B
  • 1
0
votes
2 answers

Query to find list of Column Oriented table(append_only tables) and partitioned tables

Need help How can I list the tables which are column oriented in any database? How can I list the tables which are created with partition in any database? Thanks
Gurupreet Singh Bhatia
  • 708
  • 6
  • 17
0
votes
1 answer

Recursive query in greenplum

I need to create a breadcrumb field in a child/father table in greenplum MPP The original table has 2 fields: father, child I need to extract a view with the breadcrumb For example having this records 1, 2 1, 3 2, 4 4, 5 I need to…
Stefano Ghezzi
  • 37
  • 4
0
votes
4 answers

Greenplum table definition does not show detailed child tables/partitions & distribution key

\d+ {table_name} is not showing detailed partition & distribution key information. I guess there might be some configuration parameter has not been set as previously it was showing perfect. By default it was previously showing all child tables /…
shahjapan
  • 13,637
  • 22
  • 74
  • 104
0
votes
1 answer

Greenplum Query : Best strategy 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 objects from Pre-Production Environment to Production…
Gurupreet Singh Bhatia
  • 708
  • 6
  • 17
0
votes
1 answer

Greenplum : Convert Datatype BYTEA to Text/Character

Facing issue while Convert Datatype BYTEA to Text/Character --select pg_catalog.decode('434F4D4D 4F4E', 'hex'); --select pg_catalog.encode('COMMON', 'hex'); --Query Table where col_1 has data type character varying and hex value is…
Gurupreet Singh Bhatia
  • 708
  • 6
  • 17
0
votes
1 answer

How do we work with large XML schema/XML messages on GreenPlum?

How do we work with large XML schema(XSD)/XML messages on GreenPlum? I reviwed the GreenPlum DBA guide. It talks about processing XML messages using STX tranformation. If we have an XSD and we need to process the XML messages that was compliant with…
user2647763 - RIMD
  • 74
  • 1
  • 11
0
votes
1 answer

How to delimit a compressed fixed length file with uncompressing it

I'm dealing with compressed (gzip) fixed length flat files which I then need to turn into delimited flat files so I can feed it to gpload. I was told it is possible to delimit the file without needing to decompress it, and feed it directly to gpload…
Serge
  • 608
  • 4
  • 12
  • 24
0
votes
1 answer

Greenplum - migrating segment data directories to new hardware location

I currently have my Greenplum database installed and running on a server. I have attached a new hard disk and have simply copied the master directory and all of the segment directories over because I want to point my database to the data on the new…
McLovin
  • 1,455
  • 3
  • 19
  • 37
0
votes
3 answers

How to configure Pivotal Hadoop

We are working on a Greenplum with HAWQ installed. I would like to run a hadoop-streaming job. However, it seems that hadoop is not configured or started. How can i start mapred to make sure that i can use hadoop-streaming?
Marco Puts
  • 21
1 2 3
…
53 54