Flex Parsers Reference

Verticasupports several parsers to load different types of data into flex tables:

• FAVROPARSER
• FCEFPARSER
• FCSVPARSER
• FDELIMITEDPAIRPARSER
• FDELIMITEDPARSER
• FJSONPARSER
• FREGEXPARSER

Unlike with columnar tables, you must specify which parser to use when loading flex tables. You can use each flex parser to load the parser's associated type of data into columnar tables.

All parsers store the data as a single Vmap in the LONG VARBINARY __raw__ column. If a data row is too large to fit in the column, it is rejected. Vertica supports null values for loading data with NULL-specified columns.

For information about how you can use each type of flex parser, see Using Flex Table Parsers