[HIVE-18762] Support ALTER TABLE SET OWNER command

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Metastore
• Assignee: Sergio Peña Assign to me
• Reporter: Krishna Kalyan
• Created: 21/Feb/18 20:21
• Updated: 25/Nov/19 08:32
• Resolved: 26/Jun/18 14:51

Description

Currently only a user can be a owner of hive table. It should be extended so that either user/role can be set a owner of a table.

With this support ownership of a table can be transferred to either user or role.

Should be able to run below commands and change the ownership

alter table tb1 set owner user user1;
alter table tb1 set owner role role1;

 

Issue Links

• blocks: SENTRY-2255 alter table set owner command can be executed only by user with proper privilege
• blocks: SENTRY-2338 Enable Sentry code disabled by HIVE-18762
• relates to: SPARK-30019 Add the owner property to v2 table

Sub-Tasks

• Add table ownerType to HMS thrift API: Closed
• Add table ownerType to JDO/SQL and ObjectStore: Closed
• Add test cases that verifies ALTER change owner type on the HMS: Closed
• Parse and process ALTER TABLE SET OWNER command syntax: Closed
• Backport ALTER TABLE SET OWNER patches to branch-2: Resolved