HunterL opened a new pull request #2010: URL: https://github.com/apache/hive/pull/2010
### What changes were proposed in this pull request? 1. Remove IDXS FK constraints from 3.2 Base metastore schemas 2. Update 3.1 -> 3.2 upgrade scripts to remove these constraints 3. Remove IDXS and INDEX_PARAMS tables from 4.0 entirely 4. DROP IDXS and INDEX_PARAMS in 3.2 -> 4.0 upgrade scripts ### Why are the changes needed? The INDEX commands were removed from the Hive DDL in 3.0 https://issues.apache.org/jira/browse/HIVE-18448 - In cases where users upgrade tables with Indexes on them from 2.x these FK's make the tables undropable - In cases of fresh instances these tables are useless ### Does this PR introduce _any_ user-facing change? No. Documentation site already notes that indexes have been removed from the DDL https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Indexing ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
