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:
- Keywords and Reserved Words
- Identifiers
- Literals
- Operators
- Expressions
- Predicates
- Hints
SQL data types, including:
- Binary
- Boolean
- Character
- Date/Time
- Long
- Numeric
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.