[HIVE-11145] Remove OFFLINE and NO_DROP from tables and partitions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: Metastore, SQL
• Hadoop Flags: Incompatible change
• Release Note: OFFLINE and NO_DROP mode for partitions removed, use SQLStandardAuth or other authorization scheme to prevent partitions from being dropped or read.
• Assignee: Alan Gates
• Reporter: Alan Gates
• Created: 29/Jun/15 22:43
• Updated: 01/Oct/19 22:07
• Resolved: 16/Jul/15 00:25

Description

Currently a table or partition can be marked no_drop or offline. This prevents users from dropping or reading (and dropping) the table or partition. This was built in 0.7 before SQL standard authorization was an option.

This is an expensive feature as when a table is dropped every partition must be fetched and checked to make sure it can be dropped.

This feature is also redundant now that real authorization is available in Hive.

This feature should be removed.