#通过子查询创建表
create table DQAM3 as
select * from DQAM2 where related_alarm_cuid in (
'VENDOR_ALARM-8a49bf4322acd5a20122acd9a47e0585','VENDOR_ALARM-8a49bf4322acd5a20122acd9a52b05e4') and alarm_severity >= 4;
#删除表
drop table DQAM;
#清空表数据
truncate table zhjk;