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.