[HIVE-12746] when dropping external hive tables，hive metastore should not check the hdfs path write permission

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 1.2.1
• Component/s: Metastore
• Labels: hdfspermission metastore

Environment

hive1.2.1 hadoop2.6

• Assignee: Unassigned
• Reporter: wangfeng
• Due: 25/Dec/15
• Created: 25/Dec/15 06:22
• Updated: 16/Nov/17 05:54
• Resolved: 16/Nov/17 05:54

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

Issue Links

• duplicates: HIVE-9020 When dropping external tables, Hive should not verify whether user has access to the data.