欢迎关注Hadoop、Spark、Flink、Hive、Hbase、Flume等大数据资料分享微信公共账号:iteblog_hadoop
  1. 文章总数:1029
  2. 浏览总数:13,178,504
  3. 评论:4068
  4. 分类目录:108 个
  5. 注册用户数:6744
  6. 最后更新:2019年5月23日
过往记忆博客公众号iteblog_hadoop
欢迎关注微信公众号:
iteblog_hadoop
大数据技术博客公众号bigdata_ai
Hadoop技术博文:
bigdata_ai

Hive常用语句

显示分区

show partitions iteblog;

添加分区

ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION partition_spec 
  [LOCATION 'location1'] partition_spec [LOCATION 'location2'] ...;
 
partition_spec:
  : (partition_column = partition_col_value, partition_column = partition_col_value, ...)


ALTER TABLE iteblog ADD PARTITION (dt='2008-08-08') location '/path/to/us/part080808';
ALTER TABLE iteblog ADD PARTITION (dt='2008-08-08', country='us') location '/path/to/us/part080808';
ALTER TABLE iteblog ADD PARTITION (dt='2008-08-08', country='us') location '/path/to/us/part080808'
                        PARTITION (dt='2008-08-09', country='us') location '/path/to/us/part080809';

删除分区

ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec[, PARTITION partition_spec, ...]

ALTER TABLE iteblog DROP PARTITION (dt='2008-08-08', country='us');

修改分区

ALTER TABLE iteblog PARTITION (dt='2008-08-08') SET LOCATION "new location";
ALTER TABLE iteblog PARTITION (dt='2008-08-08') RENAME TO PARTITION (dt='20080808');

添加列

ALTER TABLE iteblog ADD COLUMNS (col_name STRING);

修改列

CREATE TABLE iteblog (a int, b int, c int);

// will change column a's name to a1
ALTER TABLE iteblog CHANGE a a1 INT; 

// will change column a's name to a1, a's data type to string, and put it after column b. The new table's structure is: b int, a1 string, c int
ALTER TABLE iteblog CHANGE a a1 STRING AFTER b; 

// will change column b's name to b1, and put it as the first column. The new table's structure is: b1 int, a string, c int
ALTER TABLE iteblog CHANGE b b1 INT FIRST; 

修改表属性

alter table iteblog set TBLPROPERTIES ('EXTERNAL'='TRUE');
alter table iteblog set TBLPROPERTIES ('EXTERNAL'='FALSE');

表的重命名

ALTER TABLE iteblog RENAME TO new_table_name

参考:https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AddPartitions

本博客文章除特别声明,全部都是原创!
转载本文请加上:转载自过往记忆(https://www.iteblog.com/)
本文链接: 【Hive常用语句】(https://www.iteblog.com/archives/1537.html)
喜欢 (17)
分享 (0)
发表我的评论
取消评论

表情
本博客评论系统带有自动识别垃圾评论功能,请写一些有意义的评论,谢谢!