deniskuzZ commented on code in PR #5975:
URL: https://github.com/apache/hive/pull/5975#discussion_r2213358572
##########
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:
> ./beeline -u "jdbc:hive2://localhost:10001" -n hdfs
> 0: jdbc:hive2://localhost:10000> set hive.server2.enable.doAs;
````
+--------------------------------+
| set |
+--------------------------------+
| hive.server2.enable.doAs=true |
+--------------------------------+
````
> create table tab1(i int) stored as orc TBLPROPERTIES
('transactional'='true', 'transactional_properties'='insert_only');
> describe formatted tab1;
````
| OwnerType: | USER
| NULL |
| Owner: | hdfs
| NULL |
| CreateTime: | Thu Jul 17 08:19:31 PDT 2025
| NULL |
| LastAccessTime: | UNKNOWN
| NULL |
| Retention: | 0
| NULL |
| Location: |
hdfs://ns1/warehouse/tablespace/managed/hive/tab1 | NULL
|
| Table Type: | MANAGED_TABLE
| NULL
````
> !sh hdfs dfs -ls hdfs://ns1/warehouse/tablespace/managed/hive/
````
drwxrwx---+ - hdfs hive 0 2025-07-17 08:19
hdfs://ns1/warehouse/tablespace/managed/hive/tab1
````
> ./beeline -u "jdbc:hive2://localhost:10001" -n hive
> drop table tab1
Table `tab1` is gone since `hive` is part of the owner group.
--
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
