CREATE-VIEW

Name

CREATE VIEW

Description

该语句用于创建一个逻辑视图 语法：

1. CREATE VIEW [IF NOT EXISTS]
2. [db_name.]view_name
3. (column1[ COMMENT "col comment"][, column2, ...])
4. AS query_stmt

说明：

  • 视图为逻辑视图，没有物理存储。所有在视图上的查询相当于在视图对应的子查询上进行。
  • query_stmt 为任意支持的 SQL

Example

  1. 在 example_db 上创建视图 example_view

1. CREATE VIEW example_db.example_view (k1, k2, k3, v1) 2. AS 3. SELECT c1 as k1, k2, k3, SUM(v1) FROM example_table 4. WHERE k1 = 20160112 GROUP BY k1,k2,k3; 2. 创建一个包含 comment 的 view

1. CREATE VIEW example_db.example_view 2. ( 3. k1 COMMENT "first key", 4. k2 COMMENT "second key", 5. k3 COMMENT "third key", 6. v1 COMMENT "first value" 7. ) 8. COMMENT "my first view" 9. AS 10. SELECT c1 as k1, k2, k3, SUM(v1) FROM example_table 11. WHERE k1 = 20160112 GROUP BY k1,k2,k3;

Keywords

1. CREATE, VIEW

Best Practice