-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/33464/
-----------------------------------------------------------
Review request for Ambari, Jonathan Hurley, Nate Cole, Sumit Mohanty, and Sid
Wagle.
Bugs: AMBARI-10679
https://issues.apache.org/jira/browse/AMBARI-10679
Repository: ambari
Description
-------
Refactor serviceconfighosts, hostconfigmapping , and configgrouphostmapping to
use host_id instead of host_name
Diffs
-----
ambari-server/src/main/java/org/apache/ambari/server/controller/internal/ConfigGroupResourceProvider.java
3fcb84b
ambari-server/src/main/java/org/apache/ambari/server/controller/internal/UpgradeResourceProvider.java
82b7307
ambari-server/src/main/java/org/apache/ambari/server/orm/cache/ConfigGroupHostMapping.java
5c26a6c
ambari-server/src/main/java/org/apache/ambari/server/orm/cache/ConfigGroupHostMappingImpl.java
54e1ca0
ambari-server/src/main/java/org/apache/ambari/server/orm/cache/HostConfigMapping.java
269daa9
ambari-server/src/main/java/org/apache/ambari/server/orm/cache/HostConfigMappingImpl.java
407aeb6
ambari-server/src/main/java/org/apache/ambari/server/orm/dao/ConfigGroupHostMappingDAO.java
592679e
ambari-server/src/main/java/org/apache/ambari/server/orm/dao/HostConfigMappingDAO.java
9bc1235
ambari-server/src/main/java/org/apache/ambari/server/orm/dao/HostDAO.java
6442bf5
ambari-server/src/main/java/org/apache/ambari/server/orm/entities/ConfigGroupHostMappingEntity.java
261bbe8
ambari-server/src/main/java/org/apache/ambari/server/orm/entities/ConfigGroupHostMappingEntityPK.java
3ee2b6c
ambari-server/src/main/java/org/apache/ambari/server/orm/entities/HostConfigMappingEntity.java
1411a67
ambari-server/src/main/java/org/apache/ambari/server/orm/entities/HostConfigMappingEntityPK.java
16111fb
ambari-server/src/main/java/org/apache/ambari/server/orm/entities/ServiceConfigEntity.java
1a31252
ambari-server/src/main/java/org/apache/ambari/server/state/Cluster.java
847e349
ambari-server/src/main/java/org/apache/ambari/server/state/Clusters.java
80ac6a7
ambari-server/src/main/java/org/apache/ambari/server/state/cluster/ClusterImpl.java
6055eb8
ambari-server/src/main/java/org/apache/ambari/server/state/cluster/ClustersImpl.java
70788ff
ambari-server/src/main/java/org/apache/ambari/server/state/configgroup/ConfigGroup.java
a4cc6ac
ambari-server/src/main/java/org/apache/ambari/server/state/configgroup/ConfigGroupFactory.java
d4597af
ambari-server/src/main/java/org/apache/ambari/server/state/configgroup/ConfigGroupImpl.java
ffa085a
ambari-server/src/main/java/org/apache/ambari/server/state/host/HostImpl.java
41cfee7
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog210.java
0373aac
ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql b6f2aaa
ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql 25685e5
ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql 9ade56f
ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql
feaeae9
ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql 03f1ec8
ambari-server/src/test/java/org/apache/ambari/server/controller/AmbariManagementControllerTest.java
06f9e8a
ambari-server/src/test/java/org/apache/ambari/server/controller/internal/ConfigGroupResourceProviderTest.java
db324e5
ambari-server/src/test/java/org/apache/ambari/server/orm/dao/ConfigGroupDAOTest.java
2adbf9d
ambari-server/src/test/java/org/apache/ambari/server/orm/dao/HostConfigMappingDAOTest.java
ec1289a
ambari-server/src/test/java/org/apache/ambari/server/state/ConfigGroupTest.java
28059c0
ambari-server/src/test/java/org/apache/ambari/server/state/ConfigHelperTest.java
930e45f
ambari-server/src/test/java/org/apache/ambari/server/state/cluster/ClusterTest.java
e076d4e
ambari-server/src/test/java/org/apache/ambari/server/state/svccomphost/ServiceComponentHostTest.java
fde1945
ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeTest.java
ddfab75
Diff: https://reviews.apache.org/r/33464/diff/
Testing
-------
Local unit tests passed, except for an unrelated failure in
KerberosServiceMetaInfoTest
Applied DB changes to a cluster, and was able to create config groups, override
properties, etc.
SQL commands:
ALTER TABLE serviceconfighosts DROP CONSTRAINT serviceconfighosts_pkey;
ALTER TABLE serviceconfighosts ADD COLUMN host_id BIGINT NOT NULL;
ALTER TABLE serviceconfighosts ADD CONSTRAINT serviceconfighosts_pkey PRIMARY
KEY (service_config_id, host_id);
ALTER TABLE serviceconfighosts ADD CONSTRAINT FK_scvhosts_host_id FOREIGN KEY
(host_id) REFERENCES hosts (host_id);
ALTER TABLE serviceconfighosts DROP COLUMN hostname;
ALTER TABLE hostconfigmapping DROP CONSTRAINT hostconfigmapping_pkey;
ALTER TABLE hostconfigmapping DROP CONSTRAINT fk_hostconfmapping_host_name;
ALTER TABLE hostconfigmapping ADD COLUMN host_id BIGINT NOT NULL;
ALTER TABLE hostconfigmapping ADD CONSTRAINT hostconfigmapping_pkey PRIMARY KEY
(cluster_id, host_id, type_name, create_timestamp);
ALTER TABLE hostconfigmapping ADD CONSTRAINT FK_hostconfmapping_host_id FOREIGN
KEY (host_id) REFERENCES hosts (host_id);
ALTER TABLE hostconfigmapping DROP COLUMN host_name;
ALTER TABLE configgrouphostmapping DROP CONSTRAINT configgrouphostmapping_pkey;
ALTER TABLE configgrouphostmapping DROP CONSTRAINT fk_hostconfmapping_host_name;
ALTER TABLE configgrouphostmapping ADD COLUMN host_id BIGINT NOT NULL;
ALTER TABLE configgrouphostmapping ADD CONSTRAINT configgrouphostmapping_pkey
PRIMARY KEY (config_group_id, host_id);
ALTER TABLE configgrouphostmapping ADD CONSTRAINT FK_cghm_host_id FOREIGN KEY
(host_id) REFERENCES hosts (host_id);
ALTER TABLE configgrouphostmapping DROP COLUMN host_name;
Thanks,
Alejandro Fernandez