Directed query restrictions

In general, directed queries support only SELECT statements as input. Within that broad restriction, a number of specific restrictions apply to input queries. Vertica handles all restrictions through optimizer-generated warnings. The sections below divide these restrictions into several categories.

Tables, views, and projections

Input queries cannot query the following objects:

• Tables without projections

• Tables with access policies

• System and data collector tables, except explicit and implicit references to V_CATALOG.DUAL

• Views

• Projections

Functions

Input queries cannot include the following functions:

• Vertica meta-functions

• Pattern-matching functions

• GROUPING_ID with no arguments

Language elements

Input queries cannot include the following:

• Hints

• WITH clauses when materialization is enabled

• Date/time literals that reference the current time, such as NOW or YESTERDAY

Data types

Input queries cannot include the following data types:

• Spatial data types: GEOMETRY and GEOGRAPHY

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