hiveserver2 Thrift Interface With Perl

2013-05-14 Thread Dave Cardwell
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 transl

Re: hiveserver2 Thrift Interface With Perl

2013-05-14 Thread Prasad Mujumdar
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

Max Size of Hive String Type

2013-05-14 Thread Peter Chu
Hi, The results of my hive jobs is inserted in a MySql db. One of the tables in MySql has a field of text type, which corresponds to the String type in Hive's external table. We now have some rows (though very small amount) that exceeds the limit of text type (65k chars). We are thinking of

Re: hiveserver2 Thrift Interface With Perl

2013-05-14 Thread Carl Steinbach
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 wrote: > >HiveServer2 uses Thrift SASL transport by default. AFAIK, Thrift > doesn't support sasl transport for perl. In order to connect from a pe

Review Request: Import/Export wiki

2013-05-14 Thread Lefty Leverenz
The Hive IMPORT and EXPORT wiki had incomplete syntax and needed examples, so I've updated it. - The examples are based on the test suite. - The overview comes from the description of HIVE-1918. If you find any errors or want to add more information, please let me know (or edit the wiki you