hive 表分区,
set hive.exec.dynamic.partition=true; set hive.exec.dynamic.partition.mode=nonstrict;set hive.exec.dynamic.partitions.pernode=50000; set hive.exec.dynamic.partitions.partitions=50000; set hive.exec.max.created.files=500000; set mapred.reduce.tasks =20000; set hive.merge.mapfiles=true;
drop table testpart; create table testpart( col1 string,col2 string) partitioned by (col3 string);
alter table testpart drop partition (col3 ='a'); alter table testpart add partition (col3 ='a');
desc testpart; show partitions testpart;
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。