oozie job fails with shell action containing simple hive select statement in kerberos environment.

[#1]

I am not able to execute oozie job with shell action containing simple hive select statement in kerberos environment. it does not generate any error log, but oozie workflow fails with error code JA018. I have also defined credentials in workflow. please let me know if any one have faced similar issue.

workflow.pngshellscript.pngoozie-job-error.png

[#2]

From the error code, it seems that the problem is, you do not have hive-cli-*.jar in the Oozie sharelib folder.

Could you also check the error message and post that as well?

[#3]

I am looking into the container log an I see below message.

Stdoutput 17:59:43.986 [main] ERROR org.apache.hadoop.hdfs.KeyProviderCache - Could not find uri with key [dfs.encryption.key.provider.uri] to create a keyProvider !!