Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5391

CTAS: make folder and file permission configurable

Attach filesAttach ScreenshotVotersStop watchingWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 1.9.0, 1.10.0
    • 1.11.0
    • None
    • CentOS 7, HDP 2.4

    Description

      In Drill 1.9, CREATE TABLE AS creates a folder with permissions 777, while on Drill 1.10, the same commands creates a folder with permission 775. Both drills are started with root user, installed on the same servers and accesses the same HDFS.

      Scope:
      Added new configuration option exec.persistent_table.umask which default to 002.
      Default directory permission will be 775, file - 664.
      User can modify this option on session or system level.
      If umask was set incorrectly, default umask will be used (002) and error will be logged.

      For example, if user wants to create table will full access to folders and files, he needs to update umask:
      alter session set `exec.persistent_table.umask` = '000';
      In this case folders will be created with 777 permission, files with 666.

      Attachments

        1. Drill-1-10.PNG
          3 kB
          Chua Tianxiang
        2. Drill-1-9.PNG
          3 kB
          Chua Tianxiang

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            arina Arina Ielchiieva
            tx_qubida Chua Tianxiang
            Paul Rogers Paul Rogers
            Votes:
            0 Vote for this issue
            Watchers:
            4 Stop watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment