Table Data Management

This section summarizes new options and changes in Vertica Analytic Database 8.1.x, for managing table data in a Vertica database.

Projections and Anchor Tables Required to Share Same Schema

As of release 8.1.1, Vertica requires that all projections of a given table must share the same schema. On upgrade to this version, Vertica checks whether all projections are in the same schema as their respective anchor tables. If not, Vertica moves the projections to the appropriate schema, resolving name conflicts as needed.

Support will continue for specifying schemas in statements and functions, to ensure backward compatibility with existing scripts.

New Header_Names Parameter for fcsvparser

The fcsvparser has a new HEADER_NAMES='' parameter. Use this optional parameter to override existing column names, or to add column names where they are missing. For example, to add four column headings when loading a CSV file that has none, use a definition such as this with the new parameter: 

HEADING_NAMES='NAME,CITY,STATE,ZIP'

For more information and examples, see Loading CSV Data and FCSVPARSER

For More Information

See Managing Tables, Creating Flex Tables, and Understanding Flex Tables