rtrivedi12 opened a new pull request, #4370: URL: https://github.com/apache/hive/pull/4370
The INDEX commands were removed from the Hive DDL in 3.0 https://issues.apache.org/jira/browse/HIVE-18448 Metastore schema file contains IDXS and INDEX_PARAMS table and constraint creations which are of no use. ### What changes were proposed in this pull request? 1. Remove IDXS FK constraints from 2.3.0 - > 3.0.0 upgrade meta store schema files 2. Update 3.0.0 , 3.1.0 ,3.2.0 schema scripts to remove these constraints 3. Remove IDXS and INDEX_PARAMS tables from 4.0.0, 4.0.0-alpha-1, 4.0.0-alpha-2 schema files 4. DROP IDXS and INDEX_PARAMS in 3.2 -> 4.0.0-alpha-1 upgrade scripts ### Why are the changes needed? 1. In cases where users upgrade tables with Indexes on them from 2. x these FK's make the tables undroppable and users have to manually delete constraints from metadata to drop the table successfully. 2. And for all other cases, since indexes are obsolete, these can be removed. ### Does this PR introduce _any_ user-facing change? No -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
