SAP BODS to HIVE

[former_member586390]

Hi All,

I came an situation to load data from excel to HIVE table. Seems like HIVE have 2 types of table i.e. Transaction / Non- transaction. For Non-transaction table, I was able to load the data using BODS via one-one mapping. Whereas for Transaction ( ACID) table, am getting following error.

"This command is not allowed on an ACID table abctb.sample with a non-ACID transaction manager. Insert operation failed."

While surfing across, it was advised to execute unix script before dataflow loading in BODS . Tried executing script '.sh' file, but facing an below error.

Unix Script used in BODS script object:

exec('sh','/sql/scripts/hive.sh',8);

Error occured

/sql/scripts/hive.sh: line 2: hive: command not found

Hive.sh file contains below common settings for hive:

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

SET hive.support.concurrency=true;

SET hive.enforce.bucketing=true;

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

SET hive.compactor.initiator.on=true;

SET hive.compactor.worker.threads=1;

Any help or alternate way to use HIVE transaction table via BODS would be much appreciated!!!!

Thanks in advance!!!

[former_member586390 · Accepted solution]

Hi All,

Resolved this issue. Issue is not with the script. Issue is with type of table creation at HIVE node.

Also it seems that only possibility to access HIVE table is DRILL connectivity. It cannot be access directly via HANA.

For further details, please message me .

Thanks all.

[former_member732503 · Accepted solution]

Hi Ganesan,

Can you help in the delta to a hive table using append mode in the bulk load option in DS.

Regards

Pooja.