Delete DEPLOYMENT

The DROP DEPLOYMENT statement is used to drop a deployment under Online Request mode.

DROP DEPLOYMENT deployment_name

Example:

Create a database and set it as the current database:

CREATE DATABASE db1;
-- SUCCEED
USE db1;
-- SUCCEED: Database changed

Create a table t1:

CREATE TABLE t1(col0 STRING);
-- SUCCEED

Deploy the query statement of table t1 under Online Request mode:

> DEPLOY demo_deploy select col0 from t1;
SUCCEED

View all deployments in the current database:

SHOW DEPLOYMENTS;
 ----- ------------- 
  DB    Deployment   
 ----- ------------- 
  db1   demo_deploy  
 ----- ------------- 
1 row in set

Delete the specified deployment:

DROP DEPLOYMENT demo_deploy;
-- Drop deployment demo_deploy? yes/no
-- yes
-- SUCCEED

After deletion, check the deployments under the database again, it should be an empty list:

SHOW DEPLOYMENTS;
 ---- ------------
  DB   Deployment
 ---- ------------

0 rows in set