[HIVE-1074] CREATE VIEW followup: DROP CASCADE/RESTRICT support

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.6.0
• Component/s: Views
• Assignee: John Sichi Assign to me
• Reporter: John Sichi
• Created: 20/Jan/10 22:21
• Updated: 02/May/13 02:29

Description

Current behavior is to ignore dependencies when dropping a table, leaving them dangling. Once we start tracking dependencies, we can use this information for enforcing CASCADE/RESTRICT behavior. Per SQL:2003, default should actually be RESTRICT, so we might want to introduce a non-standard INVALIDATE option for continuing to allow the current behavior.

Issue Links

• depends upon: HIVE-1073 CREATE VIEW followup: track view dependency information in metastore
• relates to: HIVE-972 Support views