MAPREDUCE服务 MRS-SHOW VIEWS:示例

时间：2024-07-02 16:40:11

示例

创建示例所需视图：

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-ALTER TABLE COMPACTION:参数描述

下一篇：MAPREDUCE服务 MRS-CarbonData表用户权限说明:Hive ACL权限