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

Storage based auth: allow option to enforce write checks for external tables

    XMLWordPrintableJSON

    Details

    • Hadoop Flags:
      Reviewed

      Description

      Under storage based authorization, we don't require write permissions on table directory for external table create/drop.
      This is because external table contents are populated often from outside of hive and are not written into from hive. So write access is not needed. Also, we can't require write permissions to drop a table if we don't require them for creation (users who created them should be able to drop them).

      However, this difference in behavior of external tables is not well documented. So users get surprised to learn that drop table can be done by just any user who has read access to the directory. At that point changing the large number of scripts that use external tables is hard.
      It would be good to have a user config option to have external tables to be treated same as managed tables.
      The option should be off by default, so that the behavior is backward compatible by default.

        Attachments

        1. HIVE-15120.1.patch
          6 kB
          Jianyong Dai
        2. HIVE-15120.2.patch
          6 kB
          Jianyong Dai
        3. HIVE-15120.3.patch
          7 kB
          Jianyong Dai
        4. HIVE-15120.4.patch
          7 kB
          Jianyong Dai

          Activity

            People

            • Assignee:
              daijy Jianyong Dai
              Reporter:
              thejas Thejas Nair
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: