Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

HBase Row Level Filtering

avatar

What are the options for Row Level filtering in HBase?

I am aware that Ranger 0.6 has this capability for Hive but I wasn't sure what is the best option for doing it in HBase.

1 ACCEPTED SOLUTION

avatar

@Andrew Watson

You can set cell level acls via the HBase shell or via HBase's Java API. This type of policy is not exposed or controlled via Ranger.

If possible, I would implement row level policies in a client-side application, as HBase's cell ACLs are expensive (additional metadata must be stored and read with every cell).

My favorite solution is to create a Phoenix View that exposes only specific rows. As noted above, your client-side app would have to decide whether to allow access to a given view.

View solution in original post

1 REPLY 1

avatar

@Andrew Watson

You can set cell level acls via the HBase shell or via HBase's Java API. This type of policy is not exposed or controlled via Ranger.

If possible, I would implement row level policies in a client-side application, as HBase's cell ACLs are expensive (additional metadata must be stored and read with every cell).

My favorite solution is to create a Phoenix View that exposes only specific rows. As noted above, your client-side app would have to decide whether to allow access to a given view.