Restrictions

Directed queries support a wide range of queries; however, a number of exceptions apply. Vertica handles all exceptions through optimizer-generated warnings. The sections below divide these restrictions into several categories.

Tables and Projections

The following restrictions apply:

Functions

Queries are not supported that include the following functions:

Operators and Clauses

Queries are not supported that include the following:

Data Types

Queries are not supported that include GEOMETRY data types.