Query Management
This section contains information on updates to Query Management for Vertica Analytic Database 8.1.x.
New Semantics for Complex Joins
With this release, Vertica introduces new semantics that allow directed queries to support complex half joins and cross joins. These semantics can also be used to construct queries that filter the results of half-join subqueries.
More Details
See Half Join and Cross Join Semantics in the Administrator's Guide.