orc表
创建具备ACID及Transactions的表
这⾥的表需要具备下⾯⼏个条件:
1. 必须以 ORC 格式存储
2. 必须分 bucket,且不能 sort
3. 必须显式声明transations
--partitioned by (createtime string)
create table if not exists user_orc(
id int,
name string,
createdate string,
updatedate date
)
clustered by (id) into 4 buckets
row format delimited fields terminated by ','
stored as orc
tblproperties ('transactional'='true');
HIVE数据库创建ORC事物表
最新推荐文章于 2024-07-24 09:15:39 发布