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.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