export gpdb

Export a region to Greenplum Database. Export is supported from partitioned GemFire regions only. Data cannot be exported from replicated regions.

Availability: Online. You must be connected in gfsh to a JMX Manager member to use this command.

Syntax:

export gpdb --region=regionpath --type=value [--remove-all-entries(=value)]

Name	Description	Default Value
‑‑region	Required. Region from which data is to be exported. Prefix the region name with a slash character.
‑‑type	Required. Specification of the functionality implemented for the export operation. UPSERT updates rows already present in the Greenplum Database table, and it inserts rows where not already present. INSERT_ALL does a Greenplum insert operation for each entry in the GemFire region. INSERT_MISSING does a Greenplum insert operation for each GemFire region entry for which there is no corresponding Greenplum row; no updates are done for existing Greenplum rows. UPDATE updates rows already present in the Greenplum Database table.
‑‑remove-all-entries	Optional boolean value that, when true, removes all GemFire entries present in the specified region when the export operation is initiated, once changes have been successfully committed to the Greenplum Database table. All exported region entries are removed, independent of which rows are updated or inserted into the Greenplum Database table.	false

Example Commands:

gfsh>export gpdb --region=/customers --type=UPSERT
GemFire entries exported : 5
Greenplum rows updated   : 5
Greenplum rows inserted  : 0
Duration                 : 0.30s

gfsh>export gpdb --region=/customers --type=INSERT_ALL --remove-all-entries=true
GemFire entries exported : 5
GemFire entries removed  : 5
Greenplum rows inserted  : 5
Duration                 : 0.25s