MapReduce服务 MRS-SHOW VIEWS:示例

时间：2023-11-01 16:25:29

MapReduce服务 MRS

示例

创建示例所需视图：

Create schema test1;Use test1;Create table t1(id int, name string);Create view v1 as select * from t1;Create view v2 as select * from t1;Create view t1view as select * from t1;Create view t2view as select * from t1; Show views;Table-------- t1view t2view v1 v2(4 rows) Show views like 'v1'; Table------- v1(1 row) Show views 'v_';Table ------- v1     v2    (2 rows)show views like 't*'; Table-------- t1view t2view Show views in test1; Table-------- t1view t2view v1 v2(4 rows)

上一篇：MapReduce服务 MRS-SHOW CREATE TABLE:示例

下一篇：MapReduce服务 MRS-SHOW CREATE TABLE:示例