使用Hive在往分桶表插入数据是报错如下

Job Submission failed with exception 'java.io.IOException(The ownership on the s                                                                                                                       taging directory /tmp/hadoop-yarn/staging/root/.staging is not as expected. It i                                                                                                                       s owned by hive. The directory must be owned by the submitter root or root)'
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.Ma                                                                                                                       pRedTask. The ownership on the staging directory /tmp/hadoop-yarn/staging/root/.                                                                                                                       staging is not as expected. It is owned by hive. The directory must be owned by                                                                                                                        the submitter root or root

解决方案

执行如下命令，把文件的所属组修改为root
hdfs dfs -chown -R root:root /tmp