使用 insert overwrite local directory '/data/hive/out' select * from cat_group; 导出hive 表数据报错:
Failed with exception Unable to move source hdfs://node1:8020/tmp/hive/hadoop/e1f5e71d-375d-4393-a07c-fe44a4a77626/hive_2022-07-21_22-18-53_655_4722056337462286090-1/-mr-10000 to destination /data/hive/out
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Unable to move source hdfs://node1:8020/tmp/hive/hadoop/e1f5e71d-375d-4393-a07c-fe44a4a77626/hive_2022-07-21_22-18-53_655_4722056337462286090-1/-mr-10000 to destination /data/hive/out
原因分析:
本地文件夹的权限问题
解决方案:
更改接收导出数据的文件夹权限
sudo chmod 777 /data/hive/out