deniskuzZ commented on code in PR #5975:
URL: https://github.com/apache/hive/pull/5975#discussion_r2213090653


##########
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:
   yes
   ````
   set hive.server2.enable.doAs=false;
   create table tab1 (c1 string, c2 string) stored as orc tblproperties 
('transactional'='true', 'transactional_properties'='insert_only');
   
   set hive.server2.enable.doAs=true;
   create table tab2 (c1 string, c2 string) stored as orc tblproperties 
('transactional'='true', 'transactional_properties'='insert_only');
   ````
   describe output
   ````
   describe formatted tab1;
   | Owner:                        | systest
   
   describe formatted tab2;
   | Owner:                        | systest
   ````
   
   hdfs dfs -ls hdfs://ns1/warehouse/tablespace/managed/hive/
   ````
   drwxrwx---+  - hive   hive          0 2025-07-17 04:26 
hdfs://ns1/warehouse/tablespace/managed/hive/tab1
   drwxrwx---+  - hive   hive          0 2025-07-17 04:26 
hdfs://ns1/warehouse/tablespace/managed/hive/tab2
   ````



-- 
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

Reply via email to