Thank you all for replies. My usecase is as follows: I want to put a table (or database) in read-only mode. Then do some operations such as taking table definition and hdfs snapshot. I want to put table in read only mode to maintain consistency. After all my operations are done, I will again put hive to read-write mode.
Sentry may not be solution as it will not handle existing transactions. creating view will not solve the purpose either if inserts are going on. - Nachiket On Wed, Mar 9, 2016 at 7:20 AM, David Capwell <[email protected]> wrote: > Could always set the tables output format to be the null output format > On Mar 8, 2016 11:01 PM, "Jörn Franke" <[email protected]> wrote: > >> What is the use case? You can try security solutions such as Ranger or >> Sentry. >> >> As already mentioned another alternative could be a view. >> >> > On 08 Mar 2016, at 21:09, PG User <[email protected]> wrote: >> > >> > Hi All, >> > I have one question about putting hive in read-only mode. >> > >> > What are the ways of putting hive in read-only mode? >> > Can I take a lock at database level to serve purpose? What will happen >> to existing transaction? My guess is it will not grant a lock until all >> transactions are complete. >> > >> > I read to change owner ship of /user/hive/warehouse/, but it is not >> full proof solution. >> > >> > Thank you. >> > >> > - PG User >> >
