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.