Yes, putting any database or any table to read-only mode will serve my purpose.
On Tue, Mar 8, 2016 at 3:15 PM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > Hive much like MSSQL or SAP ASE has multiple databases. Are you implying > to put one of these databases in READ ONLY mode? > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 8 March 2016 at 20: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 >> > >
