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

CTAS: make folder and file permission configurable

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9.0, 1.10.0
    • Fix Version/s: 1.11.0
    • Component/s: None
    • Environment:

      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-9.PNG
          3 kB
          Chua Tianxiang
        2. Drill-1-10.PNG
          3 kB
          Chua Tianxiang

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                tx_qubida Chua Tianxiang
                Reviewer:
                Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: