Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
  b=2COApy+NM1Rp3Br7MBsLc7pqGbhsr7xHdBHb6S6viIGrbPxUU/v2O2J0P0+RDCqz/iSZYVtyO0dKE/1Bd/tAe5I4g4m9srg8gIOVMjrsANnm2P6OedWUHViW0vXXFrynVuLFo6tHrOGOZjqVQdTK065+RWpfVn9ZosdT1WcDqHg=;
Message-ID: <1312962441.3547.YahooMailNeo@web110509.mail.gq1.yahoo.com>
Date: Wed, 10 Aug 2011 00:47:21 -0700 (PDT)
From: Ayon Sinha <ayonsinha@yahoo.com>
Reply-To: Ayon Sinha <ayonsinha@yahoo.com>
Subject: Adding UDF permanently to my Hive install
To: Hive Mailinglist <user@hive.apache.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1712898956-1312962441=:3547"

--0-1712898956-1312962441=:3547
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,=0AI know I have asked this question before but the answers didn't quite=
 satisfy my requirements. Our problem stems from the fact that there is not=
 built-in UDF equivalent to yearweek of Mysql. This gives the year + week c=
oncatenated, with the week starting on Sunday.=0ASo we wrote our UDF but no=
w we want it to be available to everyone in the company regardless of how t=
hey are using Hive, through web client of CLi. I want to install this jar i=
n a place where it gets added to the Hive classpath (This part is not hard)=
. Whats hard is simulating=A0=0A"create temporary function yearweek as 'cla=
ssname'"=A0=0A=0AI want the ability to have this registered permanently. I =
traced it down to FunctionRegistry class where the build-ins are registered=
 at init time and there is a statis public method available=0Apublic static=
 void registerUDF(boolean isNative, String functionName,=0A=A0 =A0 =A0 Clas=
s<? extends UDF> UDFClass, boolean isOperator) {=0A=A0 =A0 registerUDF(isNa=
tive, functionName, UDFClass, isOperator, functionName=0A=A0 =A0 =A0 =A0 .t=
oLowerCase());=0A=A0 }=0A=0Awhich I just want to trigger like FunctionRegis=
try.registerUDF(true, "yearweek", myclass, false)=0AIs there any switch/set=
ting anywhere I can trigger this ?=A0=0AI need this the most for the Hive s=
erver.=0AShort of patching the code, I can't seem to find a way.=0A=0AIdeal=
ly there would be a version like:=A0=0Acreate [permanent] function yearweek=
 as 'classname'=0A=A0=0A-Ayon=0ASee My Photos on Flickr=0AAlso check out my=
 Blog for answers to commonly asked questions.=0A
--0-1712898956-1312962441=:3547
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ar=
ial, helvetica, sans-serif;font-size:10pt"><div><span>Hi,</span></div><div>=
<span>I know I have asked this question before but the answers didn't quite=
 satisfy my requirements. Our problem stems from the fact that there is not=
 built-in UDF equivalent to yearweek of Mysql. This gives the year + week c=
oncatenated, with the week starting on Sunday.</span></div><div><span>So we=
 wrote our UDF but now we want it to be available to everyone in the compan=
y regardless of how they are using Hive, through web client of CLi. I want =
to install this jar in a place where it gets added to the Hive classpath (T=
his part is not hard). Whats hard is simulating&nbsp;</span></div><div><spa=
n>"create temporary function yearweek as 'classname'"&nbsp;</span></div><di=
v><span><br></span></div><div><span>I want the ability to have this registe=
red permanently. I traced it down to FunctionRegistry class where the
 build-ins are registered at init time and there is a statis public method =
available</span></div><div><span>=0A=0A=0A=0A=0A=0A=0A=0A=0A=0A=0A<div clas=
s=3D"p1"><span class=3D"s1">public</span> <span class=3D"s1">static</span> =
<span class=3D"s1">void</span> registerUDF(<span class=3D"s1">boolean</span=
> isNative, String functionName,</div>=0A<div class=3D"p1">&nbsp; &nbsp; &n=
bsp; Class&lt;? <span class=3D"s1">extends</span> UDF&gt; UDFClass, <span c=
lass=3D"s1">boolean</span> isOperator) {</div>=0A<div class=3D"p1">&nbsp; &=
nbsp; registerUDF(isNative, functionName, UDFClass, isOperator, functionNam=
e</div>=0A<div class=3D"p1">&nbsp; &nbsp; &nbsp; &nbsp; .toLowerCase());</d=
iv>=0A<div class=3D"p1">&nbsp; }</div><div class=3D"p1"><br></div><div clas=
s=3D"p1">which I just want to trigger like FunctionRegistry.registerUDF(tru=
e, "yearweek", myclass, false)</div><div class=3D"p1">Is there any switch/s=
etting anywhere I can trigger this ?&nbsp;</div><div class=3D"p1">I need th=
is the most for the Hive server.</div><div class=3D"p1">Short of patching t=
he code, I can't seem to find a way.</div><div class=3D"p1"><br></div><div =
class=3D"p1">Ideally there would be a version like:&nbsp;</div><div class=
=3D"p1">create [permanent] function yearweek as 'classname'</div></span></d=
iv><div>&nbsp;</div><div>-Ayon<br><a rel=3D"nofollow" target=3D"_blank" hre=
f=3D"http://www.flickr.com/photos/ayonsinha/">See My Photos on Flickr</a><b=
r><a rel=3D"nofollow" target=3D"_blank" href=3D"http://dailyadvisor.blogspo=
t.com">Also check out my Blog for answers to commonly asked questions.</a><=
br></div></div></body></html>
--0-1712898956-1312962441=:3547--