Hive建表语句详解

CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name   
[(col_name data_type [COMMENT col_comment], ...)]
[COMMENT table_comment]
[PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
[CLUSTERED BY (col_name, col_name, ...) 
[SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS]
[ROW FORMAT row_format] 
[STORED AS file_format]
[LOCATION hdfs_path]
[TBLPROPERTIES (property_name=property_value, ...)]

（1）TEMPORARY

创建临时表，会话结束表会被删除

（2）EXTERNAL

创建外部表，不加创建内部表，关于两者区别具体见： Hive内部表和外部表的区别-优快云博客

（3） PARTITION BY

创建分区表。分区表就是把一张大表的数据分散存储到多个目录下，这样在查询时就能够通过添加where子句选择所要查询的分区，提高查询效率。实际生产中常见的是按照日期进行分