[ https://issues.apache.org/jira/browse/HIVE-12746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
wangfeng updated HIVE-12746: ---------------------------- Description: 1 user1 has readonly permission on hdfs path '/user/www/seller_shop_info'; 2 user1 create external table seller_shop_info on the hdfs path; 3 user1 drop the exernal table seller_shop_info then problem occurred! hive> drop table seller_shop_info; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Table metadata not deleted since hdfs://argo/user/www/seller_shop_info is not writable by user1) because when dropping external table,hive doesnot delete hdfs path,so hive metastore should not check the hdfs write permission was: 1 user1 has read only permission on hdfs path '/user/www/seller_shop_info'; 2 user1 create external table seller_shop_info on the hdfs path; 3 user1 drop the exernal table seller_shop_info then problem occurred! hive> drop table seller_shop_info; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Table metadata not deleted since hdfs://argo/user/www/seller_shop_info is not writable by user1) because when dropping external table,hive doesnot delete hdfs path,so hive metastore should not check the hdfs write permission > when dropping external hive tables,hive metastore should not check the hdfs > path write permission > ------------------------------------------------------------------------------------------------- > > Key: HIVE-12746 > URL: https://issues.apache.org/jira/browse/HIVE-12746 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 1.2.1 > Environment: hive1.2.1 hadoop2.6 > Reporter: wangfeng > Priority: Critical > Labels: hdfspermission, metastore > Original Estimate: 168h > Remaining Estimate: 168h > > 1 user1 has readonly permission on hdfs path '/user/www/seller_shop_info'; > 2 user1 create external table seller_shop_info on the hdfs path; > 3 user1 drop the exernal table seller_shop_info > then problem occurred! > hive> drop table seller_shop_info; > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Table metadata > not deleted since hdfs://argo/user/www/seller_shop_info is not writable by > user1) > because when dropping external table,hive doesnot delete hdfs path,so hive > metastore should not check the hdfs write permission -- This message was sent by Atlassian JIRA (v6.3.4#6332)