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.

Figure: External Tables using XML Transformations

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.

• Determine the Transformation Schema

• Write a Transform

• Write the gpfdist Configuration

• Load the Data

• Transfer and Store the Data

• XML Transformation Examples