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:
- Optimizer-generated directed queries do not support queries that reference system tables or Data Collector tables. One exception applies: explicit and implicit references to
V_CATALOG.DUAL
. - Optimizer-generated directed queries do not support queries that include tables with access policies.
- Directed queries do not support tables without projections.
Functions
Queries are not supported that include the following functions:
- Vertica meta-functions
- Pattern-matching functions
GROUPING_ID
with no arguments
Operators and Clauses
Queries are not supported that include the following:
WITH
clauses when materialization is enabled.- Queries that include date/time literals that reference the current time, such as
NOW
orYESTERDAY
Data Types
Queries are not supported that include GEOMETRY data types.