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

Switch to Threaded View
Hive, mail # user - hive alter partition error


Copy link to this message
-
hive alter partition error
Huo Zhu 2013-02-05, 13:39
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: org.apache.hadoop.security.AccessControlException
org.apache.hadoop.security.AccessControlException: Permission denied:
user=web_front, access=WRITE,
inode="/logdata/uigs/web/201301/20130101":transdata:hdfs:drwxr-xr-x)

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!
--
祝好