OK, did more research and found on the github of the authors of Thrift::API::HiveClient2 some good information. Need to add sasl => 1 to the client creation method. Then it will get past the SASL issue, but will complain about Kerberos issues. Having to look further at that now (but on the trail) as the consultant we had in to set up hadoop for us set it up with no security at all. Java can digest that it seems, but not sure about the Perl module.

When I get this fully resolved, I'll update this post as others have hit this issue but didn't post solutions for others to see, or at least were simple enough for me to understand. Sort of Red Book information.

Meanwhile, has anyone run hive server2 without Kerberos and got it to work? The .pm developers notes say they've only tested with Kerberos.

Ken Hylton

ok, final message on this thread from me anyhow. It looks like the sasl=>1 in the create fixes the sasl issue. The Kerberos issue as more problematic because I did not want to go back set up Kerberos on all the boxes. A total effort because we do not use kerberos at all, so a total from the ground up effort. From what I gathered, the easiest way to do that was to start all over from the ground up with hadoop, and I have no time for that now.

So, I moved on to getting it to work via Impala and ODBC. Hopefully, that will go smoother.