hive的内部表与外部表创建.pdfVIP

ffpp119966339911119966339911的的专专栏栏 hhiivvee的的内内部部表表与与外外部部表表创创建建 分类： Hbase Hive 2013-01-0 17:24 1756人阅读 评论 (0) 收藏 举报 Hive Hbase 内表 外表 最近才接触Hive。学到了一些东西，就先记下来，免得以后忘了。 1.创建表的语句： Create [EXTERNAL] TABLE [IF NOT EXISTS] table_name [(col_name data_t pe [COMMENT col_comment], ...)] [COMMENT table_comment] [PARTITIONED BY (col_name data_t pe [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] CREATE TABLE 创建一个指定名字的表。如果相同