Hive创建表语法详解

 1 CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [database_name.]table_name
 2   [(column_name data_type [column_constraint_specification] [COMMENT column_comment], ... [constraint_specification])]
 3   [COMMENT table_comment]
 4   [PARTITIONED BY (column_name data_type [COMMENT column_comment], ...)]
 5   [CLUSTERED BY (column_name, column_name, ...) [SORTED BY (column_name [ASC|DESC], ...)] INTO number_of_buckets BUCKETS]
 6   [SKEWED BY (column_name, column_name, ...) ON ((column_value, column_value, ...), (column_value, column_value, ...), ...)
 7      [STORED AS DIRECTORIES]]
 8   [
 9     [ROW FORMAT row_format]
10    [STORED AS file_format]
11      | STORED BY 'storage.handler.class.name' [WITH SERDEPROPERTIES (...)]
12   ]
13   [LOCATION 'hdfs_path']
14   [TBLPROPERTIES (property_name=property_value, ...)]
15   [AS select_statement];
16 
17 CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [database_name.]table_name
18   LIKE existing_table_or_view_name
19   [LOCATION 'hdfs_path'];