个人感想:
当你面向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/..... '
load data in path "/.../.../tb_name/*" 无分区
load data in path "/.../.../tb_name/part_1/part_2/" 指定分区不用*
查看hive 函数
show functions
desc function extended lag
常用字符串日期转换
demo:select date_format (to_date(‘2005-01-01 13:14:20’), ‘yyyyMMdd’) ;
输出: 20050101
参考链接:
https://www.jianshu.com/p/03514d3f374e
loading… …
参考文章 https://www.cnblogs.com/shujuxiong/p/9766639.html