LABEL

Assigns a label to a statement so it can easily be identified to evaluate performance and debug problems.

LABEL hints are valid in the following statements:

• COPY
• DELETE
• EXPORT statements:
  • EXPORT TO DELIMITED
  • EXPORT TO ORC
  • EXPORT TO PARQUET
  • EXPORT TO VERTICA
• INSERT
• MERGE
• SELECT
• UPDATE
• UNION: Valid in the UNION's first SELECT statement. Vertica ignores labels in subsequent SELECT statements.

Syntax

statement-name /*+LABEL (label‑string)*/

Arguments

label‑string

A string that is up to 128 octets long. If enclosed with single quotes, label‑string can contain embedded spaces.

Examples

See Labeling Statements.