Reply
Explorer
Posts: 10
Registered: ‎07-04-2016

Can partition (or column) level permissions be given for an specified value?

Can partition (or column) level permissions be given for an specified value? For example, can we limit users to see only rows by partition date=’2016-01’ on Hive queries such as select * from partitioned_table_by_date?

Explorer
Posts: 17
Registered: ‎11-03-2016

Re: Can partition (or column) level permissions be given for an specified value?

Hi LeoS,

 

I'm not sure about the complete setup but you could use LIMIT clause in the Hive queries and prepare the Hive QL based on the user, if there is an option.  Please refer below link for the usage of limit clause. 

 

http://www.cloudera.com/documentation/cdh/5-1-x/Impala/Installing-and-Using-Impala/ciiu_limit.html

 

Cheers

Nagaraj C