IMPORT_DIRECTED_QUERIES
Imports to the database catalog directed queries from a SQL file that was generated by EXPORT_DIRECTED_QUERIES
. If no directed queries are specified, Vertica lists all directed queries in the SQL file.
Syntax
IMPORT_DIRECTED_QUERIES( 'export-file'[, 'directed-query-name[,…]' ] )
Parameters
export‑file | A SQL file generated by EXPORT_DIRECTED_QUERIES . When you run this file, Vertica creates the specified directed queries in the current database catalog. |
directed‑query‑name |
The name of a directed query that is defined in export‑file. You can specify multiple comma-delimited directed query names. If you omit this parameter, Vertica lists the names of all directed queries in export‑file. |