Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> hive alter partition error

Copy link to this message
hive alter partition error
     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

but it gave following error,

13/02/05 19:53:23 ERROR metadata.Hive: MetaException(message:Got
exception: org.apache.hadoop.security.AccessControlException
org.apache.hadoop.security.AccessControlException: 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!
Abdelrhman Shettia 2013-02-06, 20:29