Limiting access to Hive Partitions

Question

I have a Hive table Person with 50 partitions (one for each state). Is there any way I can limit access to the partitions in Hive? For e.g: I want a user to have access to partition CA and IL only, any way to implement this in Hive.

I'm on Hive 0.12 currently

One of the ways is to use Sentry tool. – Venkat Ankam Nov 04 '14 at 00:23 — Venkat Ankam, Nov 04 '14 at 00:23

score 0 · Answer 1 · answered Nov 04 '14 at 18:40

0

Having VIEWS on top of your table with specific grants to the required users is the simplest option.

answered Nov 04 '14 at 18:40

Kunal

126
1
8

I do not think that Hive 0.12 has options to restrict access. – user3646519 Nov 05 '14 at 17:16

Limiting access to Hive Partitions

1 Answers1