[ https://issues.apache.org/jira/browse/HIVE-25571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422034#comment-17422034 ]
Ayush Saxena commented on HIVE-25571: ------------------------------------- The Script works post the changes in the PR. {noformat} [INFO] ------------------------------------------------------- [INFO] T E S T S [INFO] ------------------------------------------------------- [INFO] Running org.apache.hadoop.hive.metastore.dbinstall.ITestOracle [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 79.623 s - in org.apache.hadoop.hive.metastore.dbinstall.ITestOracle [INFO] [INFO] Results: [INFO] [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0 {noformat} cc. [~ngangam] The PR changes the code in the linked jiras, Can you help give a check > Fix Metastore script for Oracle Database > ---------------------------------------- > > Key: HIVE-25571 > URL: https://issues.apache.org/jira/browse/HIVE-25571 > Project: Hive > Issue Type: Bug > Reporter: Ayush Saxena > Assignee: Ayush Saxena > Priority: Major > Labels: pull-request-available > > Error:1 > {noformat} > 354/359 CREATE UNIQUE INDEX DBPRIVILEGEINDEX ON DC_PRIVS > (AUTHORIZER,NAME,PRINCIPAL_NAME,PRINCIPAL_TYPE,DC_PRIV,GRANTOR,GRANTOR_TYPE); > Error: ORA-00955: name is already used by an existing object > (state=42000,code=955) > Aborting command set because "force" is false and command failed: "CREATE > UNIQUE INDEX DBPRIVILEGEINDEX ON DC_PRIVS > (AUTHORIZER,NAME,PRINCIPAL_NAME,PRINCIPAL_TYPE,DC_PRIV,GRANTOR,GRANTOR_TYPE);" > [ERROR] 2021-09-29 09:18:59.075 [main] MetastoreSchemaTool - Schema > initialization FAILED! Metastore state would be inconsistent! > Schema initialization FAILED! Metastore state would be inconsistent!{noformat} > Error:2 > {noformat} > Error: ORA-00900: invalid SQL statement (state=42000,code=900) > Aborting command set because "force" is false and command failed: "======= > -- HIVE-24396 > -- Create DataCo{noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)