zxl-333 commented on code in PR #5975:
URL: https://github.com/apache/hive/pull/5975#discussion_r2209681758
##########
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/HMSHandler.java:
##########
@@ -3047,7 +3047,8 @@ private boolean drop_table_core(final RawStore ms, final
String catName, final S
tableDataShouldBeDeleted = checkTableDataShouldBeDeleted(tbl,
deleteData);
if (tableDataShouldBeDeleted && tbl.getSd().getLocation() != null) {
tblPath = new Path(tbl.getSd().getLocation());
- if (!wh.isWritable(tblPath.getParent())) {
+ // HIVE-28804 drop table user should have table path and parent path
permission
Review Comment:
> @zxl-333, is it possible to delete the table under non-hive user?
Everything under the managed directory should be owned exclusively by the Hive
user
>
> *
https://cwiki.apache.org/confluence/display/Hive/Managed+vs.+External+Tables
> *
https://medium.com/@sujathamudadla1213/explain-the-purpose-of-the-hive-external-tables-and-how-do-they-differ-from-managed-tables-bd9aa6f179bc
>
> Use managed tables when Hive should manage the lifecycle of the table
Yes, not a Hive user.For example, when the hdfs user created the "test_drop"
table, the spark user was authorized by hdfs to read this table. However, the
spark user deleted the "test_drop" table. On the engine side, a successful
deletion message was received, but the metastore log showed the following
abnormal information. The hdfs file did not actually get deleted.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org
