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

SSIS Hive Task exit value is 64, container killed on request. Exit code is 143

New Contributor

I have a Hive Task defined in SSIS with the following:

SET hive.exec.dynamic.partition = true;

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

INSERT OVERWRITE TABLE pls_data.isd3_isdh_orc PARTITION (ASSETCOLLECTIONID) SELECT CONCAT('ISDH:',CAST(CAST(attributes.ORGID_PHG as BIGINT) as STRING)) ,CONCAT('ISDH:',CAST(CAST(attributes.ORGID_PHG as BIGINT) as STRING),'[SRVC]', stdsvalue(attributes.RESOURCE_TYPE)) ,attributes.ASSETCOLLECTIONID FROM isd3_isdh;

This code will run successfully in hive cli, but in SSIS, it fails with an exit value of 64. The controller job log says that the container killed on request. Exit code is 143.

I don't know if it means anything, but the only thing that looks like an error in the yarn logs output is "Interrupted while waiting for queue" and "Failed to delete tez scratch data dir..."

I'm at a loss on how to troubleshoot, any help would be greatly appreciated.

AMBARI 2.6, HDP 2.6.3, RHEL 7.4

0 REPLIES 0