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.talebzadeh@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?


On 8 March 2016 at 20:09, PG User <pguser1982@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