GET DIRECTED QUERY

Returns a list of directed queries that map to the specified input query

Syntax

GET DIRECTED QUERY input‑query

Parameters

input‑query An input query that is associated with one or more directed queries.

Returns

A list of one or more directed queries that map to the specified input query. Each list item includes six fields:

query‑name A unique identifier that is associated with this directed query and used by statements such as ACTIVATE DIRECTED QUERY.
is_active  A Boolean field that specifies whether the directed query is active.
vertica_version The Vertica version that was current when this directed query was created.
comment  A user-supplied comment specified on creation of the direct query.
creation_date The creation timestamp of this directed query.
annotated_query  The annotated query that was saved with CREATE DIRECTED QUERY.

Privileges

None required

Examples

See Getting Directed Queries in the Administrator's Guide.

See Also

V_CATALOG.DIRECTED_QUERIES