Contents

查看 DEPLOYMENT 详情

Contents

查看 DEPLOYMENT 详情#

SHOW DEPLOYMENT语句用于显示在线请求模式下某个已部署的任务的详情。

SHOW DEPLOYMENT deployment_name;

Example#

创建一个数据库，并设置为当前数据库:

CREATE DATABASE db1;
-- SUCCEED

USE db1;
-- SUCCEED: Database changed

创建一张表t1:

CREATE TABLE t1(col0 STRING);
-- SUCCEED

将一条关于表t1的查询语句部署上线：

DEPLOY demo_deploy select col0 from t1;
-- SUCCEED

查看新部署的deployment:

SHOW DEPLOYMENT demo_deploy;

 ----- ------------- 
  DB    Deployment   
 ----- ------------- 
  db1   demo_deploy  
 ----- ------------- 
 1 row in set
 
 ---------------------------------------------------------------------------------- 
  SQL                                                                               
 ---------------------------------------------------------------------------------- 
  CREATE PROCEDURE deme_deploy (col0 varchar) BEGIN SELECT
  col0
FROM
  t1
; END;  
 ---------------------------------------------------------------------------------- 
1 row in set

# Input Schema
 --- ------- ---------- ------------ 
  #   Field   Type       IsConstant  
 --- ------- ---------- ------------ 
  1   col0    Varchar   NO          
 --- ------- ---------- ------------ 

# Output Schema
 --- ------- ---------- ------------ 
  #   Field   Type       IsConstant  
 --- ------- ---------- ------------ 
  1   col0    Varchar   NO          
 --- ------- ---------- ------------

相关语句#

DROP DEPLOYMENT