退役cdh 节点 删除mysql 元数据

DELETE FROM AUDITS WHERE HOST_ID ='5';

DELETE FROM CLIENT_CONFIGS_TO_HOSTS WHERE HOST_ID='5';

DELETE FROM COMMAND_SCHEDULES WHERE HOST_ID='5';

DELETE FROM  CONFIGS WHERE HOST_ID='5';


DELETE FROM CONFIGS_AUD WHERE HOST_ID='5';

DELETE FROM HOSTS_AUD WHERE HOST_ID='5';


DELETE FROM ROLES WHERE HOST_ID='5';


DELETE FROM ROLES_AUD WHERE HOST_ID='5';
SET FOREIGN_KEY_CHECKS = 0;
DELETE FROM COMMANDS WHERE HOST_ID='5';
DELETE FROM PROCESSES WHERE HOST_ID='5';
DELETE FROM HOSTS WHERE HOST_ID='5';
SET FOREIGN_KEY_CHECKS = 1;