Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22586

Temporary table delete fails with "SemanticException No valid privileges"

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Hive
    • Labels:
      None

      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. 

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                lpinter László Pintér
                Reporter:
                lpinter László Pintér
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: