Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: domain of dave@davecardwell.co.uk
 designates 209.85.192.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPjm5WOLsjHU6ZzU4nWb=kFZVekyeYkuoJ+aq-Ypa5Y-ER9mBQ@mail.gmail.com>
References: 
 <CAPjm5WOLsjHU6ZzU4nWb=kFZVekyeYkuoJ+aq-Ypa5Y-ER9mBQ@mail.gmail.com>
From: Dave Cardwell <dave@davecardwell.co.uk>
Date: Mon, 1 Jul 2013 10:52:02 +0100
Message-ID: 
 <CAPjm5WP9VVsGFhsriQpomgrWV5ztbFTH4PD+rt_pKyQQU0Uc2w@mail.gmail.com>
Subject: Re: hiveserver2 Thrift Interface With Perl
To: user@hive.apache.org, user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=047d7b1630d1621e3704e0702f79

--047d7b1630d1621e3704e0702f79
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I just wanted to update the list to let future searchers know that I found
a solution=97David Morel of booking.com kindly shared some code with me to
get this working, which he has now released as a Perl library that has been
working well:

https://github.com/dmorel/Thrift-API-HiveClient2
https://metacpan.org/release/Thrift-API-HiveClient2

--=20
Best wishes,
Dave Cardwell.

http://davecardwell.co.uk/


On 14 May 2013 11:35, Dave Cardwell <dave@davecardwell.co.uk> wrote:

> I wrote a few reporting scripts in Perl that connected to Hive via the
> Thrift interface.
>
> Since we upgraded CDH to 4.2.0 and hiveserver2 was installed (with Hive
> 0.10.0) the scripts no longer ran due to the API changes.
>
> I regenerated the Perl modules from the .thrift files and have tried to
> translate the Java examples I=92ve found online, but cannot for the life =
of
> me get it working with the new interface.
>
> The Java examples seem to use a TOpenSessionReq class but I cannot find
> this anywhere in the generated Perl modules. If I try to skip that part a=
nd
> go straight to $client->OpenSession() without an argument, the TCLIServic=
e
> module itself complains that it cannot create a TOpenSessionResp object
> because the class is not loaded.
>
> I have attached example code. Can anyone advise me on how to get past thi=
s
> block?
>
> --
> Best wishes,
> Dave Cardwell.
>
> http://davecardwell.co.uk/
>

--047d7b1630d1621e3704e0702f79
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I just wanted to update the list to let future searchers k=
now that I found a solution=97David Morel of <a href=3D"http://booking.com"=
>booking.com</a> kindly shared some code with me to get this working, which=
 he has now released as a Perl library that has been working well:<div>

<br></div><div><a href=3D"https://github.com/dmorel/Thrift-API-HiveClient2"=
>https://github.com/dmorel/Thrift-API-HiveClient2</a><br></div><div><a href=
=3D"https://metacpan.org/release/Thrift-API-HiveClient2">https://metacpan.o=
rg/release/Thrift-API-HiveClient2</a></div>

<div class=3D"gmail_extra"><div><br>--=A0<div>Best wishes,<br>Dave Cardwell=
.</div><div><br></div><div><a href=3D"http://davecardwell.co.uk/" target=3D=
"_blank">http://davecardwell.co.uk/</a></div></div>
<br><br><div class=3D"gmail_quote">On 14 May 2013 11:35, Dave Cardwell <spa=
n dir=3D"ltr">&lt;<a href=3D"mailto:dave@davecardwell.co.uk" target=3D"_bla=
nk">dave@davecardwell.co.uk</a>&gt;</span> wrote:<br><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex">

<div dir=3D"ltr">I wrote a few reporting scripts in Perl that connected to =
Hive via the Thrift interface.<div><br></div><div>Since we upgraded CDH to =
4.2.0 and hiveserver2 was installed (with Hive 0.10.0) the scripts no longe=
r ran due to the API changes.</div>


<div><br></div><div>I regenerated the Perl modules from the .thrift files a=
nd have tried to translate the Java examples I=92ve found online, but canno=
t for the life of me get it working with the new interface.</div><div><br>


</div><div>The Java examples seem to use a=A0TOpenSessionReq class but I ca=
nnot find this anywhere in the generated Perl modules. If I try to skip tha=
t part and go straight to $client-&gt;OpenSession() without an argument, th=
e TCLIService module itself complains that it cannot create a=A0TOpenSessio=
nResp object because the class is not loaded.</div>


<div><br></div><div>I have attached example code. Can anyone advise me on h=
ow to get past this block?</div><span class=3D"HOEnZb"><font color=3D"#8888=
88"><div><br></div><div><div>--=A0<div>Best wishes,<br>Dave Cardwell.</div>=
<div>

<br></div><div><a href=3D"http://davecardwell.co.uk/" target=3D"_blank">htt=
p://davecardwell.co.uk/</a></div>
</div>
</div></font></span></div>
</blockquote></div><br></div></div>

--047d7b1630d1621e3704e0702f79--