mirror of
https://github.com/datahub-project/datahub.git
synced 2025-07-04 07:34:44 +00:00
42 lines
1.6 KiB
SQL
42 lines
1.6 KiB
SQL
create database postgrestest;
|
|
|
|
\c postgrestest;
|
|
|
|
-- create metadata aspect table
|
|
create table metadata_aspect_v2 (
|
|
urn varchar(500) not null,
|
|
aspect varchar(200) not null,
|
|
version bigint not null,
|
|
metadata text not null,
|
|
systemmetadata text,
|
|
createdon timestamp not null,
|
|
createdby varchar(255) not null,
|
|
createdfor varchar(255),
|
|
constraint pk_metadata_aspect_v2 primary key (urn,aspect,version),
|
|
metadata_json json not null
|
|
);
|
|
|
|
create index timeIndex ON metadata_aspect_v2 (createdon);
|
|
|
|
insert into metadata_aspect_v2 (urn, aspect, version, metadata, createdon, createdby, metadata_json) values(
|
|
'urn:li:corpuser:datahub',
|
|
'corpUserInfo',
|
|
0,
|
|
'{"displayName":"Data Hub","active":true,"fullName":"Data Hub","email":"datahub@linkedin.com"}',
|
|
now(),
|
|
'urn:li:corpuser:__datahub_system',
|
|
'{"displayName":"Data Hub","active":true,"fullName":"Data Hub","email":"datahub@linkedin.com"}'
|
|
), (
|
|
'urn:li:corpuser:datahub',
|
|
'corpUserEditableInfo',
|
|
0,
|
|
'{"skills":[],"teams":[],"pictureLink":"https://raw.githubusercontent.com/datahub-project/datahub/master/datahub-web-react/src/images/default_avatar.png"}',
|
|
now(),
|
|
'urn:li:corpuser:__datahub_system',
|
|
'{"skills":[],"teams":[],"pictureLink":"https://raw.githubusercontent.com/datahub-project/datahub/master/datahub-web-react/src/images/default_avatar.png"}'
|
|
);
|
|
|
|
create view metadata_aspect_view as select urn, aspect from metadata_aspect_v2 where version=0;
|
|
-- To get estimate counts of table rows after analyze
|
|
ANALYZE
|