hive加载数据权限报错

淩亂°似流年 2023-02-16 09:27 20阅读 0赞

**前提**：  
上传数据至hdfs 的/user/root/下，创建了hive的orc表，准备load数据，创建了临时的ordertmp的textfile格式表，后面用insert overwrite进目标表。

**执行load data 从/user/root/下加载数据到hive表中，报下面的权限错误。**

0: jdbc:hive2://node01:10000> load data inpath '/user/root/order/order.txt' into table ordertmp;

INFO  : Compiling command(queryId=hive_20200609152526_ab09ff14-54cf-4e3c-ac05-a47f82389b36): load data inpath '/user/root/order/order.txt' into table ordertmp
    INFO  : Semantic Analysis Completed
    INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
    INFO  : Completed compiling command(queryId=hive_20200609152526_ab09ff14-54cf-4e3c-ac05-a47f82389b36); Time taken: 0.471 seconds
    INFO  : Executing command(queryId=hive_20200609152526_ab09ff14-54cf-4e3c-ac05-a47f82389b36): load data inpath '/user/root/order/order.txt' into table ordertmp
    INFO  : Starting task [Stage-0:MOVE] in serial mode
    INFO  : Loading data to table default.ordertmp from hdfs://node01:8020/user/root/order/order.txt
    ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. org.apache.hadoop.hive.ql.metadata.HiveException: Access denied: Unable to move source hdfs://node01:8020/user/root/order/order.txt to destination hdfs://node01:8020/user/hive/warehouse/ordertmp: Permission denied: user=anonymous, access=WRITE, inode="/user/root/order":root:supergroup:drwxr-xr-x
    INFO  : Completed executing command(queryId=hive_20200609152526_ab09ff14-54cf-4e3c-ac05-a47f82389b36); Time taken: 0.289 seconds
    Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. org.apache.hadoop.hive.ql.metadata.HiveException: Access denied: Unable to move source hdfs://node01:8020/user/root/order/order.txt to destination hdfs://node01:8020/user/hive/warehouse/ordertmp: Permission denied: user=anonymous, access=WRITE, inode="/user/root/order":root:supergroup:drwxr-xr-x (state=08S01,code=1)

解决：

su hdfs

hdfs dfs -chmod -R 777 /user/root/

解决。