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).

The import system procedures generally provide the best performance for bulk importing of data, because they can utilize multiple threads and can optionally use the PUT INTO DML syntax and the skip-constraint-checks and skip-listeners connection properties to relax table constraints and bypass listeners when importing data. This can be especially helpful with HDFS-persistent tables, where constraint checks may need to access data that is persisted in HDFS rather than in operational memory.

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 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:
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: