Tables
This section summarizes the Vertica Analytic Database 8.1.x updates to regular and flex tables.
Creating a Flex Table from Query Results
The CREATE FLEX TABLE AS statement allows a user to create a flex table from the results of a query. This statement was already functional for regular tables--this feature enables it for flex tables as well.
More Details
For more information see Managing Tables, Creating Flex Tables, and Understanding Flex Tables