Does views solve your purpose? Regards Sab On 09-Mar-2016 6:23 am, "PG User" <pguser1...@gmail.com> wrote:
> 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 >>> >> >> >