hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karen Coppage via Review Board <>
Subject Re: Review Request 69254: HIVE-20818: Views created with a WHERE subquery will regard views referenced in the subquery as direct input
Date Wed, 07 Nov 2018 08:56:54 GMT

This is an automatically generated e-mail. To reply, visit:

(Updated Nov. 7, 2018, 8:56 a.m.)

Review request for hive.

Bugs: HIVE-20818

Repository: hive-git


If Hive is configured with an authorization hook like Sentry, and a view is created with a
WHERE clause referencing a different view' user has no access to, user cannot access the view
as view' is considered direct input.
WHERE IN and WHERE EXISTS cause the same issue.
Cascading views created with no WHERE clauses (i.e. with simple SELECTs and FROM clauses)
work fine.

See Jira for example

Diffs (updated)

  ql/src/java/org/apache/hadoop/hive/ql/parse/ ab63ce2bc3 
  ql/src/java/org/apache/hadoop/hive/ql/parse/ 1a2777bf45 
  ql/src/test/org/apache/hadoop/hive/ql/plan/ 6ad38b8467 




Added unit test


Karen Coppage

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message