hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abdelrhman Shettia <>
Subject Re: hive alter partition error
Date Wed, 06 Feb 2013 20:29:21 GMT
Hi  All, 

When creating a hive partition it is actually creating a dir under the table name which will
be called the partition name. It needs to have the right permissions to create this dir. In
this case, Creating the partition with the user web_front will work. 


Hortonworks, Inc.
Technical Support Engineer
Abdelrahman Shettia
Office phone: (708) 689-9609
How am I doing?   Please feel free to provide feedback to my manager Rick Morris at

On Feb 5, 2013, at 5:39 AM, Huo Zhu <> wrote:

> hi,
>      i  created a external table like this   create external table test_tb *** location
<some hdfs dir>, it was  no problem
>  now i  want to add a partition to this table, so i tried alter table test_tb add partition
(date= "2013010101")  location "201301/20130101/2013010101.lzo"
> but it gave following error,
> 13/02/05 19:53:23 ERROR metadata.Hive: MetaException(message:Got exception: Permission denied: user=web_front, access=WRITE,
> i knew partition location should be a directory,  but  why creating  partition need write
to location  ,  and more surprising is that the error said i try to write with another user
( i committed this command with mapred) 
> thanks for your help!
> -- 
> 祝好

View raw message