Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAB=riaAGquGLdPJO1XjCZq9wctNYUk06O4JRry3mWEYt=u=sYQ@mail.gmail.com>
References: 
 <CAB7tN8a+OvTXM8T==dCqxbuB2AX6eqUrrjo0zi2iMqoz3WUbRg@mail.gmail.com>
	<1240D87E-6BBF-4D6E-B5A9-B070E3ACEC9F@gmail.com>
	<CAB=riaAGquGLdPJO1XjCZq9wctNYUk06O4JRry3mWEYt=u=sYQ@mail.gmail.com>
Date: Wed, 9 Mar 2016 10:15:04 -0800
Message-ID: 
 <CAB7tN8YgUny8KQXu6N0vZfvVwgss2N4kTP3s=rbsejowYDvQNA@mail.gmail.com>
Subject: Re: read-only mode for hive
From: PG User <pguser1982@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=001a11c14f905b3342052da1add6

--001a11c14f905b3342052da1add6
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 <dcapwell@gmail.com> wrote:

> Could always set the tables output format to be the null output format
> On Mar 8, 2016 11:01 PM, "J=C3=B6rn Franke" <jornfranke@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 <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
>>
>

--001a11c14f905b3342052da1add6
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thank you all for replies.<div><br></div><div>My usecase i=
s as follows:</div><div>I want to put a table (or database) in read-only mo=
de. Then do some operations such as taking table definition and hdfs snapsh=
ot. I want to put table in read only mode to maintain consistency. After al=
l my operations are done, I will again put hive to read-write mode.</div><d=
iv><br></div><div>Sentry may not be solution as it will not handle existing=
 transactions.</div><div>creating view will not solve the purpose either if=
 inserts are going on.</div><div><br></div><div>- Nachiket</div><div><br></=
div><div><br></div></div><div class=3D"gmail_extra"><br><div class=3D"gmail=
_quote">On Wed, Mar 9, 2016 at 7:20 AM, David Capwell <span dir=3D"ltr">&lt=
;<a href=3D"mailto:dcapwell@gmail.com" target=3D"_blank">dcapwell@gmail.com=
</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin=
:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir=3D"ltr">Cou=
ld always set the tables output format to be the null output format</p><div=
 class=3D"HOEnZb"><div class=3D"h5">
<div class=3D"gmail_quote">On Mar 8, 2016 11:01 PM, &quot;J=C3=B6rn Franke&=
quot; &lt;<a href=3D"mailto:jornfranke@gmail.com" target=3D"_blank">jornfra=
nke@gmail.com</a>&gt; wrote:<br type=3D"attribution"><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex">What is the use case? You can try security solutions such as Range=
r or Sentry.<br>
<br>
As already mentioned another alternative could be a view.<br>
<br>
&gt; On 08 Mar 2016, at 21:09, PG User &lt;<a href=3D"mailto:pguser1982@gma=
il.com" target=3D"_blank">pguser1982@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; Hi All,<br>
&gt; I have one question about putting hive in read-only mode.<br>
&gt;<br>
&gt; What are the ways of putting hive in read-only mode?<br>
&gt; 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 tr=
ansactions are complete.<br>
&gt;<br>
&gt; I read to change owner ship of /user/hive/warehouse/, but it is not fu=
ll proof solution.<br>
&gt;<br>
&gt; Thank you.<br>
&gt;<br>
&gt; - PG User<br>
</blockquote></div>
</div></div></blockquote></div><br></div>

--001a11c14f905b3342052da1add6--