Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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!
--
祝好
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB