Uploaded image for project: 'Sentry'
  1. Sentry
  2. SENTRY-922

INSERT OVERWRITE DIRECTORY permission not working correctly

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.7.0
    • Component/s: Sentry
    • Labels:
      None

      Description

      Run the following command with correct URI permissions:

      INSERT OVERWRITE DIRECTORY '/tmp/test' select * FROM sample_07 LIMIT 100;
      

      without "LOCAL" keyword, sentry will complain the following:

      Error: Error while compiling statement: FAILED: SemanticException No valid privileges
       Required privileges for this query: Server=server1->URI=file:///tmp/test->action=*; (state=42000,code=40000)
      

      However, after giving permission to "file:///tmp/test", query finished with data in "hdfs:///tmp/test", even though no permission to "hdfs:///tmp/test" was given.

        Attachments

        1. SENTRY-922.2.patch
          3 kB
          Yibing Shi
        2. SENTRY-922.1.patch
          3 kB
          Yibing Shi

          Activity

            People

            • Assignee:
              Yibing Yibing Shi
              Reporter:
              ericlin Eric Lin
            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: