Alter Hive replication policy examples

A scheduled query once created can be modified using ALTER and DROP.

  • Modify schedule: Alter scheduled query repl_policyname cron '<value>';
  • Run now: Alter scheduled query repl_policyname execute;
  • Delete a policy: Drop scheduled query repl_policyname;
  • Pause a policy: Alter scheduled query repl_policyname disabled;
  • Resume a policy: Alter scheduled query repl_policyname enabled;
  • Get list of all scheduled policies: select * from information_schema.scheduled_queries;