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)