删除外部表源数据

alter table dwd.portfolio_info set tblproperties(‘external’ = ‘false’);
truncate table dwd_farx.portfolio_info;
alter table dwd_farx.portfolio_info set tblproperties(‘external’=‘true’);