Hive中的分区分桶约束,元数据解析

Hive中的分区分桶主外键约束

建表

create table user_partition_bucket_pk(id int comment 'ID',name string comment '姓名',age int comment '年龄',id1 int, id2 int, 
primary key(id1, id2) disable novalidate) comment '测试分桶'
PARTITIONED BY (date_id string)
clustered by (id) sorted by (id) into 4 buckets row format delimited fields terminated by '\t';

create table user_partition_bucket_fk(id int comment 'ID',name string comment '姓名',age int comment '年龄',id1 int, id2 int, 
constraint c1 foreign key(id1, id2) references user_partition_bucket_pk(id1, id2) disable novalidate) comment '测试分桶'
PARTITIONED BY (date_id string)
clustered by (id) sorted by (id) into 4 buckets row format delimited fields terminated by '\t';

desc formatted user_partition_bucket_pk

# col_name	data_type	comment
id	int	ID
name	strin