SQL reference

Vertica offers a robust set of SQL elements that allow you to manage and analyze massive volumes of data quickly and reliably, including:

• Language elements such as keywords, operators, expressions, predicates, and hints

• Data types including complex types

• Functions including Vertica-specific functions that take advantage of Vertica's unique column-store architecture

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