1、创建三张表
CREATE TABLE IF NOT EXISTS billdb.user_name(user_code STRING comment ‘客户代码’,
user_name STRING comment ‘客户名称’
);
CREATE TABLE IF NOT EXISTS billdb.user_age(user_code STRING comment ‘客户代码’,
user_age STRING comment ‘客户年龄’
);
CREATE TABLE IF NOT EXISTS billdb.user_info(
user_code STRING comment ‘客户代码’,
user_name STRING comment ‘客户名称’,
user_age STRING comment ‘客户年龄’
);
insert into table billdb.user_name values(“9999”,“升姐”);
insert into table billdb.user_age values(“9999”,“58”);
2、执行Insert语句写入数据
insert into table billdb.user_info
select t1.user_code,t1.user_name,t2.user_age from billdb.user_name t1 left join billdb.user_age t2 on t1.user_code = t2.user_code;
3、元数据管理
4、 Atlas血缘关系图
表血缘管理图:
字段血缘关系图: