ALTER TRIGGER

You add a trigger to or remove a trigger from a query pool in a plan using this command.

ALTER TRIGGER syntax

ALTER TRIGGER plan_name.name { ADD TO | DROP FROM } { POOL path | UNMANAGED }

plan_name.name
The dot-delimited names of the resource plan and trigger
path
The name of the query pool

ALTER TRIGGER example

ALTER TRIGGER rp1.slow_query DROP FROM POOL etl_pool

ALTER TRIGGER description

Adds or removes the trigger specified by plan_name.name to or from the pool identified by the path. The trigger applies only to queries in identified by the path and not to its children. Enables or disables the trigger specified by plan_name.name for unmanaged queries. The latter functionality applies to queries that are not running in low-latency analytic processing (LLAP) mode with workload management: for example, Apache Tez container queries.