What about renaming the table? To another schema with limited rights? Not sure why just flipping access grant to select only wouldn't also work, provided auth is enabled and not external.
An hdfs snapshot could also give you point -in-time copy. Set acls to restrict access if enabled. Cheers, Andrew On Wed, Mar 09, 2016 at 1:15 PM, PG User < pguser1...@gmail.com [pguser1...@gmail.com] > wrote: 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 < dcapw...@gmail.com [dcapw...@gmail.com] > wrote: Could always set the tables output format to be the null output format On Mar 8, 2016 11:01 PM, "Jörn Franke" < jornfra...@gmail.com [jornfra...@gmail.com] > 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 < pguser1...@gmail.com > [pguser1...@gmail.com] > 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
