hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karen Coppage via Review Board <nore...@reviews.apache.org>
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:
https://reviews.apache.org/r/69254/
-----------------------------------------------------------

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


Review request for hive.


Bugs: HIVE-20818
    https://issues.apache.org/jira/browse/HIVE-20818


Repository: hive-git


Description
-------

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/CalcitePlanner.java ab63ce2bc3 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 1a2777bf45 
  ql/src/test/org/apache/hadoop/hive/ql/plan/TestViewEntity.java 6ad38b8467 


Diff: https://reviews.apache.org/r/69254/diff/2/

Changes: https://reviews.apache.org/r/69254/diff/1-2/


Testing
-------

Added unit test


Thanks,

Karen Coppage


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