Member since
11-15-2017
3
Posts
1
Kudos Received
0
Solutions
11-15-2017
07:26 PM
1 Kudo
Hi Gurus, Can you please validate the expected behaviour of Ranger: I have a simple table userz with three columns: id, first_name, country. I have two groups Grp_A, Grp_B and one user User_AB who is a member of both Grp_A and Grp_B. I have a Row Level Filter Policy on the the userz table with two Row Filter Conditons: 1. Select Group = Grp_A, Access Type = Select, Row Level Filter = (country = 'US') 2. Select Group = Grp_B, Access Type = Select, Row Level Filter = (country = 'Canada') When I log into hive and do a select * from the userz table my expectation is that I will see rows where country is either US or Canada. However, only the rows of the Row Filter Condition that appears first is returned that is, if Row Level Filter = (country = 'US') is first then US rows are returned and if Row Level Filter = (country = 'Canada') is first only the Canada rows is returned. Is this the expected behaviour? Regards, Mex
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Ranger