Hi, Alex, Thanks for the reply. After fixing the permission, the query works fine.
Jessica > On Apr 11, 2015, at 12:58 PM, Alexander Pivovarov <[email protected]> > wrote: > > 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 <[email protected]> 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 >> >
