SELECT PARENT_BRAND,CHILD_BRAND,(CASE WHEN SOURCE = '' THEN 'HIVE' else SOURCE end)SOURCE FROM ps_child_parent_brand