knowledgebase:working_with_greenplum

Working with Greenplum

About Greenplum

The Greenplum Database builds on the foundations of the open source database PostgreSQL. It primarily functions as a data warehouse and utilizes a shared-nothing, massively parallel processing (MPP) architecture. In this architecture, data is partitioned across multiple segment servers, and each segment owns and manages a distinct portion of the overall data; there is no disk-level sharing nor data contention among segments.

Source: Wikipedia.

Unlike PostgreSQL, Greenplum database does not support the binary option of copy command

Select the Text Mode option to load data into Greenplum

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/working_with_greenplum.txt
  • Last modified: 14/07/2021 09:15
  • by admin