You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Jie Zhang <ji...@gmail.com> on 2015/04/11 20:07:33 UTC
create table fails with exception unable to rename tmp file
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
Re: create table fails with exception unable to rename tmp file
Posted by Jessica Zhang <ji...@gmail.com>.
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 <ap...@gmail.com> 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 <ji...@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
>>
>
Re: create table fails with exception unable to rename tmp file
Posted by Alexander Pivovarov <ap...@gmail.com>.
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 <ji...@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
>