You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@hive.apache.org by GitBox <gi...@apache.org> on 2021/02/23 16:40:29 UTC
[GitHub] [hive] HunterL opened a new pull request #2010: HIVE-24815: Remove "IDXS" Table from Metastore Schema
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] github-actions[bot] closed pull request #2010: HIVE-24815: Remove "IDXS" Table from Metastore Schema
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed pull request #2010:
URL: https://github.com/apache/hive/pull/2010
--
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] github-actions[bot] commented on pull request #2010: HIVE-24815: Remove "IDXS" Table from Metastore Schema
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on pull request #2010:
URL: https://github.com/apache/hive/pull/2010#issuecomment-855489234
This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
Feel free to reach out on the dev@hive.apache.org list if the patch is in need of reviews.
--
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org