Exporting and Importing Bulk Data from Text Files

GemFire XD provides several system procedures to help you import and export delimited data in text files. You can use these procedures to transfer data between various programs and GemFire XD. For example, you can use the procedures to import data as comma-separated values (a CSV file).

Note: As a best practice, use the SYS.CREATE_ALL_BUCKETS procedure to pre-allocate partitioned table buckets before you import any data into a partitioned table. This helps to ensure that partitioned table data is evenly distributed throughout the distributed system, even if you import table data using concurrent processes.
The import system procedures import data from a text file into a table. If the target table already contains data, you can choose to replace or append to the existing data. These import procedures are available:
The export system procedures write data from a GemFire XD database to one or more files that are stored outside of the database. You can use a procedure to export data from a table into a file or to export data from a SELECT statement result into a file. These export procedures are available: