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> 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