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:

The first three steps comprise most of the development effort. The last two steps are straightforward and repeatable, suitable for production.