Hive表DDL操作（一） 第2关：Create/Drop/Truncate 表

相关知识

为了完成本关任务，你需要掌握： 1.如何创建表； 2.如何复制表； 3.如何删除表； 4.如何截断表。

Create 创建表

创建表的语法为：

1. CREATE [TEMPOPARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.] table_name
2. 　　[(col_name data_type [COMMENT col_comment], ...)]
3. 　　[COMMENT table_comment]
4. 　　[PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
5. 　　[CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS]
6. [SKEWED BY (col_name,col_name,…) ON ([(col_value,col_value,…),…|col_value,col_value,…]) [STORED AS DIRECTORIES] ]
7. [
8. [ROW FORMAT DELIMITED [FIFLDS TERMINATED BY char [ESCAPED BY char]] [COLLECTION ITEMS TERMINATED BY char] [MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char] [NULL DEFINED AS char]
9. | SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value,property_name=property_value,…)]
10. ]
11. 　 [STORED AS file_format]
12. | STORED BY 'storage.handler.class.name' [WITH SERDEPROPERTIES (…)]
13. ]
14. [LOCATION hdfs_path]
15. [TBLPROPERTIES (property_name=property_value,…)]
16. [AS select_statement];

参数说明如下：

• TEMPOPARY：创建临时表，若未指定，则默认创建的是普通表
• EXTERNAL：创建外部表，若未指定，则默认创建的是内部表
• IF NOT EXISTS：若表不存在才创建，若未指定，