Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Oozie Workflow Error when using Hive set commands in hive scripts

Oozie Workflow Error when using Hive set commands in hive scripts

New Contributor

Hi All,

 

I am trying to create an oozie workflow which references a hive script which in turn is trying to create some tables.

 

Some of the tables are used for Acid Transactions and therefore in the beginning of the code I specified these settings

 

set hive.execution.engine=tez;

set hive.support.concurrency = true;

set hive.enforce.bucketing = true;

set hive.exec.dynamic.partition.mode = nonstrict;

set hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

set hive.compactor.initiator.on = true; set hive.compactor.worker.threads = 1;

 

When I try to run that oozie job it throws this error.

But it works fine when i try to load another hql file which just create non ORC/ACID table and uses no set commands.

 

So it seems oozie fails when we use set commands in hql file.

 

I was wondering if there is a way i an can set hive properties using oozie. I tried using properties option but it fails again!

 

I am using Hue version Hue™ 3.9.0 - The Hadoop UI

 

Also how can I run parallel hive scripts, I know in the old version of Hue we have a option to use Fork but I couldn't find this in Hue 3.9.0

 

2 REPLIES 2

Re: Oozie Workflow Error when using Hive set commands in hive scripts

Do you use the Hive or Hive2 action? (later is the recommended one)

Re: Oozie Workflow Error when using Hive set commands in hive scripts

New Contributor

Hive2

Don't have an account?
Coming from Hortonworks? Activate your account here