Hi, We wanted to avoid user from dropping table created by another user. By changing the hdfs permission of the table dir, we were able to prevent the table from getting deleted from hdfs. But unfortunately, hive deletes the metadata related to the table from the mysql metastore.
So, even when I got the following error, hive dropped the metadata. So this table wasn't accessible using show tables; etc. hive> drop table hadooptab1; FAILED: Error in metadata: MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException org.apache.hadoop.security.AccessControlException: Permission denied: user=diffUserName, access=EXECUTE, inode="warehouse-hadoop":hadoop:supergroup:rwxr-x---)FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask I am wondering if any one has any pointers to this problem. It would also help if someone could point me to the hive code where it is doing deletion. It seems that we just have to exit if hdfs throws error and should not delete metadata in this case. Appreciate you help, Ankita The information contained in this email message and its attachments is intended only for the private and confidential use of the recipient(s) named above, unless the sender expressly agrees otherwise. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws by means of email or in an attachment to email, you must select a more secure alternate means of transmittal that supports your obligations to protect such personal data. If the reader of this message is not the intended recipient and/or you have received this email in error, you must take no action based on the information in this email and you are hereby notified that any dissemination, misuse or copying or disclosure of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email and delete the original message.
