Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to explain plan for unaccessible underlying table in view

Highlighted

How to explain plan for unaccessible underlying table in view

Explorer

Hi!

We need to implement RLS (row level security) in Impala, and it works over VIEWs with some filtering and projections. Users have SELECT access to view, but does not have access to underlying table (it should hide some secret rows). But where is a problem here: when you want to explain plan for query, containing that VIEW, you got error:

 

ERROR: AuthorizationException: User 'test' does not have privileges to EXPLAIN this statement.

Is where any workaround for this issue?