SQL in Vertica

Vertica offers a robust set of SQL elements that allow you to manage and analyze massive volumes of data quickly and reliably. Vertica uses the following:

SQL language elements, including:

SQL data types, including:

SQL functions  including Vertica-specific functions that take advantage of Vertica's unique column-store architecture. For example, call ANALYZE_STATISTICS to collect and aggregate a variable amount of sample data for statistical analysis.

SQL statements that let you write robust queries to quickly return large volumes of data.