View DEPLOYMENTS List
Contents
View DEPLOYMENTS List#
The SHOW DEPLOYMENTS statement displays the tasks that have been deployed in the current database under Online Request mode.
SHOW DEPLOYMENTS;
Example#
Create a database and set it as the current database:
CREATE DATABASE db1;
-- SUCCEED: Create database successfully
USE db1;
-- SUCCEED: Database changed
Create a table t1:
CREATE TABLE t1(col0 STRING);
-- SUCCEED: Create successfully
Deploy the query statement of table t1 to OnlineServing:
DEPLOY demo_deploy select col0 from t1;
-- SUCCEED: deploy successfully
View all deployments in the current database:
SHOW DEPLOYMENTS;
----- -------------
DB Deployment
----- -------------
db1 demo_deploy
----- -------------
1 row in set