Alter statements from Owl 2.0.0 to 2.2.0
--Agent Table changes between 2.0 -> 2.2.0
ALTER TABLE public.agent
ADD COLUMN use_livy integer;
ALTER TABLE public.agent
ADD COLUMN livy_host character varying(80);
ALTER TABLE public.agent
ADD COLUMN owl_core_jar character varying(80) DEFAULT '/opt/owl/bin/owl-core-version.jar';
ALTER TABLE public.agent
ADD COLUMN owl_script character varying(80) DEFAULT '/opt/owl/bin/owlcheck';
ALTER TABLE public.agent
ADD COLUMN owl_base_path character varying(80) DEFAULT '/opt/owl/';
ALTER TABLE public.agent
ADD COLUMN owl_web_logs character varying(80) DEFAULT '/opt/owl/log';
ALTER TABLE public.agent
ADD COLUMN owl_core_logs character varying(80) DEFAULT '/opt/owl/log';
ALTER TABLE public.agent
ADD COLUMN owl_core_conf character varying(80) DEFAULT '/opt/owl/config';
ALTER TABLE public.agent
ADD COLUMN deploy_mode_default character varying(10) DEFAULT 'client';
ALTER TABLE public.agent
ADD COLUMN master_default character varying(80) DEFAULT 'yarn';
ALTER TABLE public.agent
ADD COLUMN queue_default character varying(80);
ALTER TABLE public.agent
ADD COLUMN spark_dynamic_allocation_enabled character varying(10) DEFAULT 'false';
ALTER TABLE public.agent
ADD COLUMN spark_conf_1_key character varying(100);
ALTER TABLE public.agent
ADD COLUMN spark_conf_1_value character varying(10);
ALTER TABLE public.agent
ADD COLUMN num_executors integer DEFAULT 2;
ALTER TABLE public.agent
ADD COLUMN executor_memory character varying(5) COLLATE pg_catalog."default" DEFAULT '5G'::character varying;
ALTER TABLE public.agent
ADD COLUMN free_form_append character varying(100) COLLATE pg_catalog."default";
--Agent Connections
ALTER TABLE public.agent_connection
ADD COLUMN driverlocation character varying COLLATE pg_catalog."default";
--Connections
ALTER TABLE public.connections
ADD COLUMN is_template integer DEFAULT 0;
ALTER TABLE public.connections
ADD COLUMN is_hive integer DEFAULT 0;
ALTER TABLE public.connections
ADD CONSTRAINT idx_alias UNIQUE (aliasname);
ALTER TABLE public.agent
ALTER COLUMN executor_memory TYPE CHARACTER VARYING(10) COLLATE pg_catalog."default";
ALTER TABLE public.agent
ALTER COLUMN executor_memory SET DEFAULT '6g';
ALTER TABLE public.agent
ADD COLUMN driver_memory character varying(10) COLLATE pg_catalog."default" DEFAULT '4g';
ALTER TABLE public.agent
ADD COLUMN num_cores Integer DEFAULT NULL;
ALTER TABLE public.connections
ADD COLUMN use_pwd_mgr integer DEFAULT 0;
ALTER TABLE public.connections
ADD COLUMN is_kerb integer DEFAULT 0;
ALTER TABLE public.connections
ADD COLUMN keytab character varying COLLATE pg_catalog."default";
ALTER TABLE public.connections
ADD COLUMN principal character varying COLLATE pg_catalog."default";
ALTER TABLE public.dataset_schema
ADD COLUMN is_pii integer DEFAULT 0;
ALTER TABLE public.dataset_schema
ADD COLUMN is_mnpi integer DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN rule_total_score SET DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN validate_src_total_score SET DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN dupe_total_score SET DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN fpg_total_score SET DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN outlier_total_score SET DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN schema_total_score SET DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN record_total_score SET DEFAULT 0;
ALTER TABLE public.dataset_scoring
ALTER COLUMN datashape_total_score SET DEFAULT 0;
ALTER TABLE public.owl_check_history
ADD COLUMN owl_check_json character varying COLLATE pg_catalog."default";
CREATE INDEX idx_ds_run_key_nm
ON public.data_preview USING btree
(dataset COLLATE pg_catalog."default", run_id, row_key COLLATE pg_catalog."default", field_nm COLLATE pg_catalog."default")
INCLUDE(dataset, run_id, row_key, field_nm)
TABLESPACE pg_default;
ALTER TABLE public.owl_catalog
ADD COLUMN semantic integer DEFAULT 0;
Last updated