export gpdb
Export a region to GPDB. 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.
|
|
‑‑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 GPDB table. All exported region entries are removed, independent of which rows are updated or inserted into the GPDB 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