Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11145

Remove OFFLINE and NO_DROP from tables and partitions

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.0.0
    • Component/s: Metastore, SQL
    • Labels:
      None
    • 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.

      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.

        Attachments

        1. HIVE-11145.patch
          80 kB
          Alan Gates
        2. HIVE-11145.2.patch
          499 kB
          Alan Gates
        3. HIVE-11145.3.patch
          512 kB
          Alan Gates

          Activity

            People

            • Assignee:
              alangates Alan Gates
              Reporter:
              alangates Alan Gates
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: