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.

Ranger Row Level Filtering

Solved Go to solution
Highlighted

Ranger Row Level Filtering

New Contributor

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

42624-table.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Ranger Row Level Filtering

Explorer

Yes, this is expected behavior. Ranger matches first row-filter policy line-item (in the same order as specified in the policy).

View solution in original post

2 REPLIES 2
Highlighted

Re: Ranger Row Level Filtering

Explorer

Yes, this is expected behavior. Ranger matches first row-filter policy line-item (in the same order as specified in the policy).

View solution in original post

Highlighted

Re: Ranger Row Level Filtering

New Contributor

Thanks for the confirmation.

Don't have an account?
Coming from Hortonworks? Activate your account here