[HIVE-22586] Temporary table delete fails with "SemanticException No valid privileges"

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Hive
• Assignee: László Pintér
• Reporter: László Pintér
• Created: 05/Dec/19 16:37
• Updated: 20/Apr/20 07:59
• Resolved: 20/Apr/20 07:59

Description

When using Hive with Sentry, at the moment is not possible to delete a temporary tables without granting ALL privileges on database/table level.

Temporary tables are strongly bound to the session, and it is only visible/accessible to the user who owns the session, and the table exists until the session is not closed. 

Since temporary tables only exists on session level, and they are not connected to any database, checking the privileges with Sentry is unnecessary. 

Issue Links

• is duplicated by: HIVE-20051 Skip authorization for temp tables