Skip to main content

CANCEL TABLE_SERVICE

Description​

Cancels an in-progress on-demand table service run. Use this to stop a table service operation that was manually triggered and is currently executing.

Only table services configured with TRIGGER_MODE = 'ON_DEMAND' can be cancelled. Services running in automatic mode are not eligible for cancellation.

Note that the SQL statement does not end with ;

Syntax​

CANCEL TABLE_SERVICE
  LAKE = <string>
  DATABASE = <string>
  TABLE = <string>
  SERVICE = 'CLUSTER'

Example​

CANCEL TABLE_SERVICE
  LAKE = 'my_lake'
  DATABASE = 'my_database'
  TABLE = 'my_table'
  SERVICE = 'CLUSTER'

Sample response

Required parameters​

  • LAKE: Specify the name of the lake where the target table exists.
  • DATABASE: Specify the name of the database where the target table exists.
  • TABLE: Specify the name of the table whose service run you want to cancel.
  • SERVICE: Specify the table service to cancel. Currently, only 'CLUSTER' is supported.