Vertica Array and Row types
Vertica Array and Row data types can be manipulated in Semarchy xDI and proceed in the data flows.
Vertica Array and Row data types are designed in the Vertica metadata. They are automatically reverse engineered with the tables or can be manually designed. See Getting Started with Vertica database.
To read data within Vertica Array and Row types:
Create a mapping.
Add the Vertica table containing Array and Row types as the source.
Add any target datastore.
Map the source columns to the target columns.
Finally, run the mapping.