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

when try to make the path specified in the create DDL's location,it report HiveAccessControlException Permission denied

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments


    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 0.13.1, 1.1.0
    • None
    • Authorization
    • None


      If the specific location does not exist while creating table,It'll try to make a directory which matches the location. In the process ,if the location's upper paths also don't exist,It'll find a path "PRTPATH" which is the specific location's forward path,and then create the missing paths under the PRTPATH. But It'll check all files' privilege under the PRTPATH,so even though current user has privilege on the PRTPATH,it'll fail on privilege check

      [root@xxx opt]# hdfs dfs -ls /tmp
      drwxr-xr-x - user1 hadoop 0 2015-11-03 19:14 /tmp/user1
      [root@xxx opt]# hdfs dfs -ls /tmp/user1
      Found 2 items
      drwxr-xr-x - admin hadoop 0 2015-11-03 19:14 /tmp/user1/admin_t2
      drwxr-xr-x - user1 hadoop 0 2015-11-03 19:13 /tmp/user1/user1_t1

      0: jdbc:hive2://> create external table user1_t3(id int, name string) row format delimited fields terminated by ',' stored as textfile location '/tmp/user1/user1_t3';
      Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=user1, type=USER] does not have following privileges for operation CREATETABLE [[INSERT, DELETE, OBJECT OWNERSHIP] on Object [type=DFS_URI, name=hdfs://hacluster/tmp/user1/user1_t3]] (state=42000,code=40000)


        Issue Links


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


            forrest_lv forrest lv Assign to me
            forrest_lv forrest lv




                Issue deployment