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.

Use nested query in Ranger row level filter.

Highlighted

Use nested query in Ranger row level filter.

New Contributor

Hi all,

I want to use nested query in ranger row level filter policy.

Ex id IN (select id from Table1 where username = 'a1')  this query is working properly. 

But I want to use:

id IN ((select id from Table1 where username = 'a1') OR (select id from Table1 where username = 'a2')) 

 
it gives error 
 Error: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.ParseException: line 1:188 cannot recognize input near '(' 'select' 'id' in expression specification (state=42000,code=40000)