[HIVE-22948] QueryCache: Treat query cache locations as temporary storage

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2, 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Query Planning
• Assignee: Gopal Vijayaraghavan
• Reporter: Gopal Vijayaraghavan
• Created: 29/Feb/20 05:09
• Updated: 17/Nov/22 08:50
• Resolved: 30/Mar/20 06:33

Description

The WriteEntity with a query cache query is considered for user authorization without having direct access for users.

https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/command/CommandAuthorizerV2.java#L111

      if (privObject instanceof WriteEntity && ((WriteEntity)privObject).isTempURI()) {
        // do not authorize temporary uris
        continue;
      }

is not satisfied by the queries qualifying for the query cache.

Issue Links

• relates to: HIVE-21386 Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache