Use nested query in Ranger row level filter.

anjali_shevadka · ‎08-28-2018

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)