Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of vinod@vinodsingh.com designates
 209.85.216.48 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKOFcwrDQSo+hEeA1d0niaHU16H4CfOxheGsB06K==cXtcsUYQ@mail.gmail.com>
References: 
 <CAKOFcwqz-wBvF3VGT5v+F_Nu9HQThgPBvYCJgkYk=bXPkRMZ+Q@mail.gmail.com>
 <CAMY2jQ+ONaSH-FQSJrw_kC8M5Ag-SDBemfvZUTy6VgeDtkkwOw@mail.gmail.com>
 <CAKOFcwrDQSo+hEeA1d0niaHU16H4CfOxheGsB06K==cXtcsUYQ@mail.gmail.com>
From: =?UTF-8?B?4KS14KS/4KSo4KWL4KSmIOCkuOCkv+CkguCkuQ==?=
 <vinod@vinodsingh.com>
Date: Mon, 10 Dec 2012 22:06:17 +0530
Message-ID: 
 <CAMY2jQ+oCbKrjZ0t8SNOVAshqgCdrHGY3qWGBNFG74yEZm7kjQ@mail.gmail.com>
Subject: Re: Running commands at hive cli or hive thirft startup
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=20cf3005140a44baef04d0822b3d

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

I did not tried thrift, so not sure whether this will work or not.

Thanks,
Vinod

On Mon, Dec 10, 2012 at 9:31 PM, John Omernik <john@omernik.com> wrote:

> Will that work for my thrift server connections?
>
>
> On Sun, Dec 9, 2012 at 7:56 PM, =E0=A4=B5=E0=A4=BF=E0=A4=A8=E0=A5=8B=E0=
=A4=A6 =E0=A4=B8=E0=A4=BF=E0=A4=82=E0=A4=B9 <vinod@vinodsingh.com> wrote:
>
>> Put a .hiverc file in your home directory containing commands, Hive CLI
>> will execute all of them at startup.
>>
>> Thanks,
>> Vinod
>>
>> On Sun, Dec 9, 2012 at 10:25 PM, John Omernik <john@omernik.com> wrote:
>>
>>> I am looking for ways to streamline some of my analytics. One thing I
>>> notice is that when I use hive cli, or connect to my hive thrift server=
,
>>> there are a some commands I always end up running for my session.  If I
>>> have multiple CLIs or connections to Thrift, then I have to run it each
>>> time. If I lose a connection to hive thrift, I have to run them.  Etc e=
tc.
>>>
>>> My thought was, is there a way that upon opening a hive cli or
>>> connection to a hive thrift server, could I have certain commands be
>>> executed?
>>>
>>> These commands include a use command to get me to a specific database
>>> (perhaps there is a default database config variable?) or loading up al=
l
>>> the temporary functions I use (UDFs) .
>>>
>>> For example, I have a UDF to do URL decoding:
>>>
>>> CREATE TEMPORARY FUNCTION uridecode AS 'org.domain.analytics.URIDECODE;
>>>
>>> Can I get this to run auto magically at hive cli start or thrift server
>>> connection?
>>>
>>> If not, could we build it in that we can add UDFs to hive without doing
>>> a recompile that stay in permanently?
>>>
>>> I would welcome discussion on this!
>>>
>>>
>>>
>>
>

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

I did not tried thrift, so not sure whether this will work or not.<div><br =
clear=3D"all"><div>Thanks,<br>Vinod<br><br></div><div class=3D"gmail_quote"=
>On Mon, Dec 10, 2012 at 9:31 PM, John Omernik <span dir=3D"ltr">&lt;<a hre=
f=3D"mailto:john@omernik.com" target=3D"_blank">john@omernik.com</a>&gt;</s=
pan> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Will that work for my thrift server connecti=
ons?=C2=A0<div class=3D"HOEnZb"><div class=3D"h5"><br><br><div class=3D"gma=
il_quote">
On Sun, Dec 9, 2012 at 7:56 PM, =E0=A4=B5=E0=A4=BF=E0=A4=A8=E0=A5=8B=E0=A4=
=A6 =E0=A4=B8=E0=A4=BF=E0=A4=82=E0=A4=B9 <span dir=3D"ltr">&lt;<a href=3D"m=
ailto:vinod@vinodsingh.com" target=3D"_blank">vinod@vinodsingh.com</a>&gt;<=
/span> wrote:<br>


<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Put a .hiverc file in your home directory co=
ntaining commands, Hive CLI will execute all of them at startup.<br clear=
=3D"all">


<div><br></div><div>Thanks,<br>Vinod<br><br></div><div><div><div class=3D"g=
mail_quote">On Sun, Dec 9, 2012 at 10:25 PM, John Omernik <span dir=3D"ltr"=
>&lt;<a href=3D"mailto:john@omernik.com" target=3D"_blank">john@omernik.com=
</a>&gt;</span> wrote:<br>


<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">I am looking for ways to streamline some of =
my analytics. One thing I notice is that when I use hive cli, or connect to=
 my hive thrift server, there are a some commands I always end up running f=
or my session. =C2=A0If I have multiple CLIs or connections to Thrift, then=
 I have to run it each time. If I lose a connection to hive thrift, I have =
to run them. =C2=A0Etc etc.=C2=A0<div>


<br></div><div>My thought was, is there a way that upon opening a hive cli =
or connection to a hive thrift server, could I have certain commands be exe=
cuted?</div><div><br></div><div>These commands include a use command to get=
 me to a specific database (perhaps there is a default database config vari=
able?) or loading up all the temporary functions I use (UDFs) .=C2=A0</div>


<div><br></div><div>For example, I have a UDF to do URL decoding:</div><div=
><br></div><div>CREATE TEMPORARY FUNCTION uridecode AS &#39;org.domain.anal=
ytics.URIDECODE;</div><div><br></div><div>Can I get this to run auto magica=
lly at hive cli start or thrift server connection?</div>


<div><br></div><div>If not, could we build it in that we can add UDFs to hi=
ve without doing a recompile that stay in permanently? =C2=A0</div><div><br=
></div><div>I would welcome discussion on this!</div><div><br></div><div><b=
r>


</div>
</blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br></div>

--20cf3005140a44baef04d0822b3d--