@Rajeev Vandakar I agree with @mqureshi in that you cannot set authorizations on the partition level for your use case. If you do not have Ranger then it is best to take his suggested solution of creating views for different groups. However, it would be more beneficial to install Ranger and use that. As of HDP 2.5, Ranger supports Row-Level Filtering. That enables you to set permissions on rows within your table. So, for your case, your filter would be based on the condition "country={country}". This way, users will only see rows/data to countries they have permissions/access to, even though all the data is in the same table. Below is a link to a blog about Row-Level Filtering (amongst other Ranger capabilities) that uses an example to filter by country (similar to what you want to do): https://hortonworks.com/blog/eyes-dynamic-column-masking-row-level-filtering-hdp2-5/ For details on how to setup row-level filtering take a look here: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_security/content/ranger_row_level_filtering_in_hive.html As always, if you find our responses helpful, don't forget to "accept" answer.
... View more
