Support Questions
Find answers, ask questions, and share your expertise

oozie hive2 Action - kerb ( unable retrive delegation token )

oozie hive2 Action - kerb ( unable retrive delegation token )

Explorer

I am working in cluster environment for HDP 2.6; I am trying to create oozie workflow using hive2 action to call simple hive script.

oozie workflow keeps on failing with "unable to retrive delegation token for user <abcd> ( id job submitted with )"

I have seen several links and none of them helps; is there any solution exists ? I see couple of solution which might work on VM ( where you can su with oozie/hive users and kinit ), but this is not possible in realtime working environment.

job.properties. ----------------

nameNode=hdfs://<hostname>:8020
job-tracker=<hostname>:8050
oozie.use.system.libpath=true
oozie.wf.application.path=${nameNode}/user/${user.name}/hive_action
dry_run=false
security_enabled=false

workflow.xml ----------------

<workflow-app xmlns='uri:oozie:workflow:0.1' name='hive-wf'>
... <credentials> <credential name='howlauth' type='hive2'>
<property> <name>hive2.jdbc.url</name>
<value>jdbc:hive2//hostname:100000/default</value>
</property>
<property>
<name>hive2.server.principal</name>
<value>hive/hostname@abc.com</value>
</property>
</credential> </credentials>
... <action name='hive212' cred='howlauth'>
<hive> <job-tracker>JT</job-tracker>
<name-node>NN</name-node>
<configuration> <property> <name>oozie.action.sharelib.for.hive</name>
<value>hive2</value> </property>
<property> <name>oozie.action.launcher.main.class</name> <value>org.apache.oozie.action.hadoop.hive2Main</value> </property>
</configuration>
<jdbc-url></jdbc-url>
<password>####</password>
<script>###script_location###</script>
</hive> </action> ... </workflow-app>