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 dave@davecardwell.co.uk
 designates 209.85.192.175 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CACf6RryBCEK7ipeEEAxM9oUWyjEm2_tyE5K5Mqemp31W4Dn7=g@mail.gmail.com>
References: 
 <CAPjm5WOLsjHU6ZzU4nWb=kFZVekyeYkuoJ+aq-Ypa5Y-ER9mBQ@mail.gmail.com>
 <CAC-RAHNhK-s1Mvhe_wOVdhh9AOQtTsXVca6JLJGFFE7W6FmBvg@mail.gmail.com>
 <CACf6RryBCEK7ipeEEAxM9oUWyjEm2_tyE5K5Mqemp31W4Dn7=g@mail.gmail.com>
From: Dave Cardwell <dave@davecardwell.co.uk>
Date: Wed, 15 May 2013 10:20:11 +0100
Message-ID: 
 <CAPjm5WM_OBWqcDEFRJ_t9OjNOTw4F0fVpFBhDWjFZKkJCuCSvg@mail.gmail.com>
Subject: Re: hiveserver2 Thrift Interface With Perl
To: user@hive.apache.org
Cc: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=047d7b33d5f41f23e604dcbe4374

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

Hi guys,

I had already used the NOSASL setting to turn off that authentication, so
was able to connect to the cluster fine.

My issue is with how to use the new API to execute a query and get the
response.


--=20
Best wishes,
Dave Cardwell.

http://davecardwell.co.uk/


On 15 May 2013 00:05, Carl Steinbach <cwsteinbach@gmail.com> wrote:

> This SASL module for Perl may be of interest:
>
> http://search.cpan.org/~gbarr/Authen-SASL-2.16/
>
>
>
> On Tue, May 14, 2013 at 9:44 AM, Prasad Mujumdar <prasadm@cloudera.com>wr=
ote:
>
>>
>>    HiveServer2 uses Thrift SASL transport by default. AFAIK, Thrift
>> doesn't support sasl transport for perl. In order to connect from a perl
>> thrift client, you need to turn off the SASL in HiveServer2. This can be
>> done by setting a property hive.server2.authentication to NOSASL in the
>> hive-site.xml. Note that with this change, all other clients like JDBC
>> applications and beeline, will also need to make non-sasl connection to
>> HiveServer2. The JDBC connection URL should
>> be jdbc:hive2://<host>:<port>/default;auth=3DnoSasl
>>
>> thanks
>> Prasad
>>
>>
>> On Tue, May 14, 2013 at 3:35 AM, 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 lif=
e 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=
 and
>>> go straight to $client->OpenSession() without an argument, the TCLIServ=
ice
>>> 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
>>> this block?
>>>
>>> --
>>> Best wishes,
>>> Dave Cardwell.
>>>
>>> http://davecardwell.co.uk/
>>>
>>
>>
>

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

<div dir=3D"ltr">Hi guys,<div><br></div><div style>I had already used the N=
OSASL setting to turn off that authentication, so was able to connect to th=
e cluster fine.</div><div style><br></div><div style>My issue is with how t=
o use the new API to execute a query and get the response.</div>

</div><div class=3D"gmail_extra"><br clear=3D"all"><div><br>--=A0<div>Best =
wishes,<br>Dave Cardwell.</div><div><br></div><div><a href=3D"http://daveca=
rdwell.co.uk/" target=3D"_blank">http://davecardwell.co.uk/</a></div></div>
<br><br><div class=3D"gmail_quote">On 15 May 2013 00:05, Carl Steinbach <sp=
an dir=3D"ltr">&lt;<a href=3D"mailto:cwsteinbach@gmail.com" target=3D"_blan=
k">cwsteinbach@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmai=
l_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left=
:1ex">

<div dir=3D"ltr">This SASL module for Perl may be of interest:<br><div><br>=
</div><div><a href=3D"http://search.cpan.org/~gbarr/Authen-SASL-2.16/" targ=
et=3D"_blank">http://search.cpan.org/~gbarr/Authen-SASL-2.16/</a></div><div=
>
<br>
</div></div><div class=3D"HOEnZb"><div class=3D"h5">
<div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Tue, May 1=
4, 2013 at 9:44 AM, Prasad Mujumdar <span dir=3D"ltr">&lt;<a href=3D"mailto=
:prasadm@cloudera.com" target=3D"_blank">prasadm@cloudera.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"><div dir=3D"ltr"><br><div>=A0 =A0HiveServer2=
 uses Thrift SASL transport by default. AFAIK, Thrift doesn&#39;t support s=
asl transport for perl. In order to connect from a perl thrift client, you =
need to turn off the SASL in HiveServer2. This can be done by setting a pro=
perty hive.server2.authentication to NOSASL in the hive-site.xml. Note that=
 with this change, all other clients like JDBC applications and beeline, wi=
ll also need to make non-sasl connection to HiveServer2. The JDBC connectio=
n URL should be=A0jdbc:hive2://&lt;host&gt;:&lt;port&gt;/default;auth=3DnoS=
asl</div>


<div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra">thanks</div=
><div class=3D"gmail_extra"><span><font color=3D"#888888">Prasad</font></sp=
an><div><div><br><br><div class=3D"gmail_quote">On Tue, May 14, 2013 at 3:3=
5 AM, Dave Cardwell <span dir=3D"ltr">&lt;<a href=3D"mailto:dave@davecardwe=
ll.co.uk" target=3D"_blank">dave@davecardwell.co.uk</a>&gt;</span> wrote:<b=
r>


<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;p=
adding-left:1ex"><div dir=3D"ltr">I wrote a few reporting scripts in Perl t=
hat 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.1=
0.0) the scripts no longer 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><font color=3D"#888888"><div><br></di=
v><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></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>

--047d7b33d5f41f23e604dcbe4374--