4.5.2 数据清洗
1. 删除数据
delete from common_example001 where partition like 'data_operate' and s1='zs';
2. 清空分区数据
truncate systable common_example001 partitions data_operate ;
truncate mapping mappping_example001 partitions data_operate ;
3. 清空分区数据,保留表结构
truncate table common_example001;
truncate mapping common_example001;
4. 删除表指定分区
drop table common_example001 partitions teststream;
drop mapping mappping_example001 partitions teststream;
5. 删除表
drop table common_example001;
drop mapping mappping_example001;