MapReduce服务 MRS-DELETE:示例

时间：2025-02-12 15:03:47

MapReduce服务 MRS

示例

非事务表场景：

清空表数据

--创建表并插入数据 create table tb_del as select * from (values(1,'suse'),(2,'centos'),(3,'euler')) as t (id,os);select * from tb_del; id |   os   ----|--------  1 | suse     2 | centos   3 | euler  (3 rows)--不支持通过where子句删除单条数据delete from tb_del where id =1;Query 20201116_081955_00027_iyct5@default@HetuEngine failed: This connector only supports delete where one or more partitions are deleted entirely for Non-Transactional tables--清空表数据delete from tb_del;select * from tb_del; id | os ----|----(0 rows)

删除分区表hive.web.page_views中partition(date='2020-07-17', country='US')的分区：
```
delete from hive.web.page_views where ds=date '2020-07-17' and country='US';
```

事务表场景：删除指定记录

--创建事务表     create table tb_trans(a int,b string) with (transactional=true);CREATE TABLE--插入数据insert into tb_trans values(1,'a'),(2,'b'),(3,'c');INSERT: 3 rows--删除数据delete from tb_trans where a=1;DELETE: 1 row

上一篇：MapReduce服务 MRS-UNION | INTERSECT | EXCEPT:INTERSECT

下一篇：MapReduce服务 MRS-UNION | INTERSECT | EXCEPT:EXCEPT