hive 常用命令，

个人感想：

当你面向google/ baidu 找不到你需要的东西的时候，静下心来，
打开下面这个链接，对你会有很大的帮助

一个通往快乐的链接地址

内部表改成外部表

alter table db_name.dwd_ptnr_netcard_xb_order_day set tblproperties('EXTERNAL'='TRUE');

外部表删除表时先删除分区

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

You can use ALTER TABLE DROP PARTITION to drop a partition for a table. This removes the data and metadata for this partition. The data is actually moved to the .Trash/Current directory if Trash is configured, unless PURGE is specified, but the metadata is completely lost (see Drop Table above).

存储格式转换

ALTER TABLE db_name.dwd_ptnr_netcard_xb_order_day SET FILEFORMAT ORC

修复分区

MSCK REPAIR TABLE table_name;

删除表

DROP TABLE IF EXISTS DB_NAME.TB_NAME

LOAD DATA

move 移动到表路径下面（默认3个副本，如果复制… … ）
load data in path '' ....
copy 本地复制到表路径下面
load data local in path '/home/..... '

loading… …

参考文章 https://www.cnblogs.com/shujuxiong/p/9766639.html