drop table if exists rig_xml; | |
create table rig_xml ( | |
well_uid text, -- e.g. W-12 | |
well_name text, -- e.g. 6507/7-A-42 | |
rig_uid text, -- e.g. xr31 | |
rig_name text, -- e.g. Deep Drill #5 | |
rig_owner text, -- e.g. Deep Drilling Co. | |
rig_contact text, -- e.g. John Doe | |
rig_email text, -- e.g. John.Doe@his-ISP.com | |
doc xml | |
) distributed by (rig_uid); |