Create Database and Store Configs

create table configs_prior_patch_<service-name> as 

select cc.config_id,cc.type_name,cc.config_data ,cc.config_attributes ,service_name,sc.version,sc.note  from serviceconfig sc inner join serviceconfigmapping scm 

on sc.service_config_id =scm.service_config_id  inner join clusterconfig cc on cc.config_id = scm.config_id 

where sc.service_name in (<service-name>);

update clusterconfig a set config_data = (select config_data from configs_prior_patch_nifi b where a.type_name = b.type_name and version = <latest-config-version-before-upgrade> and service_name = <service-name>),

    config_attributes = (select config_attributes from configs_prior_patch_nifi b where a.type_name = b.type_name and version = <latest-config-version-before-upgrade> and service_name = <service-name>)

    where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = <service-name> and version =

    (select max(version) from serviceconfig where service_name = <service-name>)) );

Before Upgrade:

create table configs_prior_patch_nifi as 

select cc.config_id,cc.type_name,cc.config_data ,cc.config_attributes ,service_name,sc.version,sc.note  from serviceconfig sc inner join serviceconfigmapping scm 

on sc.service_config_id =scm.service_config_id  inner join clusterconfig cc on cc.config_id = scm.config_id 

where sc.service_name in ('NIFI');

​

After Upgrade

update clusterconfig a set config_data = (select config_data from configs_prior_patch_nifi b where a.type_name = b.type_name and version = 4 and service_name = 'NIFI'),

    config_attributes = (select config_attributes from configs_prior_patch_nifi b where a.type_name = b.type_name and version = 4 and service_name = 'NIFI')

    where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'NIFI' and version =

    (select max(version) from serviceconfig where service_name = 'NIFI')) );