maybe user which runs hive cli does not have write permissions on hdfs://zhangj05-a:8020/user/hive/warehouse/reporting.db
who is hdfs://zhangj05-a:8020/user/hive/warehouse/reporting.db owner? what user runs hive cli? On Sat, Apr 11, 2015 at 11:07 AM, Jie Zhang <jiezh2...@gmail.com> wrote: > Hi, > > I hit the following error when running a CTAS statment. Looks like a hdfs > permission issue since the temp file can not be renamed. Maybe I miss > setting some property? my hive version is 0.14.0. Any help is appreciated! > > hive> create table reporting.test2 as select count(uuid) from store.imr; > > Moving data to: > hdfs://zhangj05-a:8020/user/hive/warehouse/reporting.db/test2 > > Failed with exception Unable to rename: > hdfs://zhangj05-a:8020/tmp/hive/zhangj/d79a6a8f-5e04-4bba-945f-eb6e010806b6/hive_2015-04-11_17-32-16_509_1852350843116431139-1/-ext-10001 > to: hdfs://zhangj05-a:8020/user/hive/warehouse/reporting.db/test2 > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.MoveTask > > > Jessica >