Transforming XML Data
The HAWQ data loader gpfdist provides transformation features to load XML data into a table and to write data from the HAWQ to XML files. The following diagram shows gpfdist performing an XML transform.
To load or extract XML data:
- Determine the Transformation Schema
- Write a Transform
- Write the gpfdist Configuration
- Load the Data
- Transfer and Store the Data
The first three steps comprise most of the development effort. The last two steps are straightforward and repeatable, suitable for production.