| 能力 | 行级增删改 |
|---|---|
| 格式 | ORC + delta |
| 合并 | compactor |
| 限制 | 需事务表与分桶 |
事务表
事务表
CREATE TABLE dim_customer_acid (
customer_id STRING,
customer_name STRING
)
CLUSTERED BY (customer_id) INTO 8 BUCKETS
STORED AS ORC
TBLPROPERTIES ('transactional'='true');
UPDATE dim_customer_acid SET customer_name='new' WHERE customer_id='C001';小文件与 delta 堆积会让读取变慢，需关注合并任务是否正常执行。