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 or YESTERDAY

Data types

Queries are not supported that include the following data types:

• Spatial data types: GEOMETRY and GEOGRAPHY

• Complex data types: non-native arrays, rows, maps, and sets

  Note

  Directed queries support native (one-dimensional) arrays.