Use delegation token(from oozie in a java action) through hive JDBC to talk to hive server 2

[Jary Du <ja...@gmail.com>]

Hi,

Currently I am having an issue really need some help from hive community. 
We are trying kerberize our hadoop cluster including hive server2 and oozie. My oozie job spins off a java action in data node which tries to connect to kerberized hive server 2. 
There is no user’s kerberos keytab for authentication. So I can only use delegation token passed by oozie in the java action to connect to hive server 2. 

My question is: is there any way that I can use delegation token in a oozie java action to connect to hive server 2? If so, how can I do it through hive JDBC?


Thanks
Jary

Re: Use delegation token(from oozie in a java action) through hive JDBC to talk to hive server 2

[Prasad Mujumdar <pr...@apache.org>]

Hi Jary,

   Hive JDBC does support delegation token based client connection for
Oozie. Please refer to client connection details [1] on the wiki.
The Hive side changes were added in Hive 0.13 and the Oozie side support
for Hive2 action was added in Oozie 4.2. You might want to refer to Oozie
docs for Hive2 action setup.

thanks
Prasad

[1] -
https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Multi-UserScenariosandProgrammaticLogintoKerberosKDC


On Thu, Aug 13, 2015 at 11:59 AM, Jary Du <ja...@gmail.com> wrote:

> Hi,
>
> Currently I am having an issue really need some help from hive community.
> We are trying kerberize our hadoop cluster including hive server2 and
> oozie. My oozie job spins off a java action in data node which tries to
> connect to kerberized hive server 2.
> There is no user’s kerberos keytab for authentication. So I can only use
> delegation token passed by oozie in the java action to connect to hive
> server 2.
>
> My question is: is there any way that I can use delegation token in a
> oozie java action to connect to hive server 2? If so, how can I do it
> through hive JDBC?
>
>
> Thanks
> Jary