hadoop 运维

netstat -n | awk  '/^tcp/ {++S[$NF]} END {for(a in S) print a,s[a]}'

ALTER TABLE logs DROP IF EXISTS PARTITION(year = 2012, month = 12, day = 18);

ALTER TABLE hotel_info_customer_comment_format_code DROP IF EXISTS PARTITION(dp = hotel_all, dt = 20170408 );

hive> alter table hotel_info_customer_comment_format_code drop partition(dp='hotel_all',dt='20170408');

ps aufx | grep hive | grep root

发现是root用户启动的hive，重启集群，全部用hadoop用户