DIRECTED_QUERIES
Returns information about directed queries.
| Column Name | Data Type | Description |
|---|---|---|
query_name
|
VARCHAR
|
This directed query's unique identifier, used by statements such as ACTIVATE DIRECTED QUERY. |
is_active
|
BOOLEAN
|
Specifies whether the directed query is active. |
vertica_version
|
VARCHAR
|
The Vertica version used when this directed query was created. |
comment
|
VARCHAR
|
A user-supplied comment specified on creation of the directed query, up to 128 characters. |
creation_date
|
TIMESTAMPTZ
|
Specifies when the directed query was created. |
input_query
|
VARCHAR
|
The input query that is associated with this directed query. Multiple directed queries can map to the same input query. |
annotated_query
|
VARCHAR
|
The directed query that was saved with CREATE DIRECTED QUERY. |
Privileges
Truncated Query Results
Query results for the fields input_query and annotated_query are truncated after 8192 characters. You can get the full content of both fields in two ways:
- Use the statement
GET DIRECTED QUERY. - Use
EXPORT_CATALOGto export directed queries.
