Repository: sentry Updated Branches: refs/heads/master b9d2107f4 -> 03a872923
SENTRY-2024: Drop Index that includes AUTHZ_OBJ_NAME (Na Li, reviewed by Sergio Pena) Project: http://git-wip-us.apache.org/repos/asf/sentry/repo Commit: http://git-wip-us.apache.org/repos/asf/sentry/commit/03a87292 Tree: http://git-wip-us.apache.org/repos/asf/sentry/tree/03a87292 Diff: http://git-wip-us.apache.org/repos/asf/sentry/diff/03a87292 Branch: refs/heads/master Commit: 03a8729237d46d9677ae5b55644b035551dc7b6c Parents: b9d2107 Author: Sergio Pena <[email protected]> Authored: Wed Nov 22 15:13:43 2017 -0600 Committer: Sergio Pena <[email protected]> Committed: Wed Nov 22 15:14:34 2017 -0600 ---------------------------------------------------------------------- .../java/org/apache/sentry/provider/db/service/model/package.jdo | 3 +-- .../src/main/resources/007-SENTRY-1365.derby.sql | 2 +- .../src/main/resources/007-SENTRY-1365.mysql.sql | 2 +- .../src/main/resources/007-SENTRY-1365.oracle.sql | 2 +- .../src/main/resources/007-SENTRY-1365.postgres.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql | 2 +- .../src/main/resources/sentry-postgres-2.0.0.sql | 2 +- .../src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql | 2 +- 11 files changed, 11 insertions(+), 12 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo b/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo index 2f2aabb..d883c51 100644 --- a/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo +++ b/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo @@ -247,8 +247,7 @@ <datastore-identity> <column name="AUTHZ_OBJ_ID"/> </datastore-identity> - <index name="AuthzObjNameID" unique="true"> - <field name="authzObjName"/> + <index name="AUTHZ_SNAPSHOT_ID_INDEX" unique="false"> <field name="authzSnapshotID"/> </index> <!-- http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql index 13708ba..0235ab3 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql @@ -10,7 +10,7 @@ CREATE TABLE AUTHZ_PATHS_MAPPING ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); -- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX AUTHZOBJNAMEID ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME, AUTHZ_SNAPSHOT_ID); +CREATE INDEX AUTHZ_SNAPSHOT_ID_INDEX ON AUTHZ_PATHS_MAPPING (AUTHZ_SNAPSHOT_ID); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE AUTHZ_PATH http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql index a7db1b7..c34755a 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql @@ -9,7 +9,7 @@ CREATE TABLE `AUTHZ_PATHS_MAPPING` ) ENGINE=INNODB; -- Constraints for table `AUTHZ_PATHS_MAPPING` for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX `AUTHZOBJNAMEID` ON `AUTHZ_PATHS_MAPPING` (`AUTHZ_OBJ_NAME`, `AUTHZ_SNAPSHOT_ID`); +CREATE INDEX `AUTHZ_SNAPSHOT_ID_INDEX` ON `AUTHZ_PATHS_MAPPING` (`AUTHZ_SNAPSHOT_ID`); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE `AUTHZ_PATH` ( http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql index ebb981a..f65d215 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql @@ -10,7 +10,7 @@ CREATE TABLE AUTHZ_PATHS_MAPPING ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); -- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX AUTHZOBJNAMEID ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME, AUTHZ_SNAPSHOT_ID); +CREATE INDEX AUTHZ_SNAPSHOT_ID_INDEX ON AUTHZ_PATHS_MAPPING (AUTHZ_SNAPSHOT_ID); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE AUTHZ_PATH http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql index e0b560c..5d163b2 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql @@ -9,7 +9,7 @@ CREATE TABLE "AUTHZ_PATHS_MAPPING" ); -- Constraints for table "AUTHZ_PATHS_MAPPING" for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX "AUTHZOBJNAMEID" ON "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_NAME", "AUTHZ_SNAPSHOT_ID"); +CREATE INDEX "AUTHZ_SNAPSHOT_ID_INDEX" ON "AUTHZ_PATHS_MAPPING" ("AUTHZ_SNAPSHOT_ID"); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE "AUTHZ_PATH" http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql index 2c1268a..69d8a24 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql @@ -202,7 +202,7 @@ CREATE TABLE AUTHZ_PATHS_MAPPING( ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHSCO7K_PK PRIMARY KEY (AUTHZ_OBJ_ID); -- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX AUTHZOBJNAMEID ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME, AUTHZ_SNAPSHOT_ID); +CREATE INDEX AUTHZ_SNAPSHOT_ID_INDEX ON AUTHZ_PATHS_MAPPING (AUTHZ_SNAPSHOT_ID); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE AUTHZ_PATH http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql index 1c51049..6c55d28 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql @@ -202,7 +202,7 @@ CREATE TABLE AUTHZ_PATHS_MAPPING ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); -- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX AUTHZOBJNAMEID ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME, AUTHZ_SNAPSHOT_ID); +CREATE INDEX AUTHZ_SNAPSHOT_ID_INDEX ON AUTHZ_PATHS_MAPPING (AUTHZ_SNAPSHOT_ID); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE AUTHZ_PATH http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql index 9f61154..df34f87 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql @@ -239,7 +239,7 @@ CREATE TABLE `AUTHZ_PATHS_MAPPING` ) ENGINE=INNODB; -- Constraints for table `AUTHZ_PATHS_MAPPING` for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX `AUTHZOBJNAMEID` ON `AUTHZ_PATHS_MAPPING` (`AUTHZ_OBJ_NAME`, `AUTHZ_SNAPSHOT_ID`); +CREATE INDEX `AUTHZ_SNAPSHOT_ID_INDEX` ON `AUTHZ_PATHS_MAPPING` (`AUTHZ_SNAPSHOT_ID`); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE `AUTHZ_PATH` ( http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql index 58241e5..6526ab2 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql @@ -217,7 +217,7 @@ CREATE TABLE AUTHZ_PATHS_MAPPING ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); -- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX AUTHZOBJNAMEID ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME, AUTHZ_SNAPSHOT_ID); +CREATE INDEX AUTHZ_SNAPSHOT_ID_INDEX ON AUTHZ_PATHS_MAPPING (AUTHZ_SNAPSHOT_ID); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE AUTHZ_PATH http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql index 5d52136..25f3356 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql @@ -226,7 +226,7 @@ CREATE TABLE "AUTHZ_PATHS_MAPPING" ); -- Constraints for table "AUTHZ_PATHS_MAPPING" for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX "AUTHZOBJNAMEID" ON "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_NAME", "AUTHZ_SNAPSHOT_ID"); +CREATE INDEX "AUTHZ_SNAPSHOT_ID_INDEX" ON "AUTHZ_PATHS_MAPPING" ("AUTHZ_SNAPSHOT_ID"); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE "AUTHZ_PATH" http://git-wip-us.apache.org/repos/asf/sentry/blob/03a87292/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql index 5e8be9c..cf5a450 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql @@ -20,7 +20,7 @@ ALTER TABLE AUTHZ_PATHS_SNAPSHOT_ID ADD CONSTRAINT AUTHZ_SNAPSHOT_ID_PK PRIMARY ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHSCO7K_PK PRIMARY KEY (AUTHZ_OBJ_ID); -- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] - CREATE UNIQUE INDEX AUTHZOBJNAME ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME); + CREATE INDEX AUTHZ_SNAPSHOT_ID_INDEX ON AUTHZ_PATHS_MAPPING (AUTHZ_SNAPSHOT_ID); -- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] CREATE TABLE AUTHZ_PATH
