Sqoop job in Oozie using HUE on Yarn

[Harish Krishnan <ha...@gmail.com>]

I'm trying to run a sqoop job from HUE using Oozie on Yarn.
It keeps failing with error

Logs not available for attempt_1400007822283_0078_m_000000_0. Could be
caused by the rentention policy.

I'm running the following command

export  -files
/home/hadoop_sa/wallet/cwallet.sso,/home/hadoop_sa/wallet/ewallet.p12,/home/hadoop_sa/wallet/sqlnet.ora,/home/hadoop_sa/wallet/tnsnames.ora
--connect 'jdbc:oracle:thin:@xxxxxxxx' --table xxxxxxxxxx --columns
xxxxxxxxxxx --export-dir /path/to/dir --input-fields-terminated-by '|'

I tried setting oozie.use.system.libpath=true in the Hue job properties and
copied the oracle related jars (required for wallet) to
/user/oozie/share/lib/sqoop/ but that didnt help. I'm curious to know from
where oozie will pick up the jars?

Any suggestions/help will be highly appreciated.

Thanks & Regards,
Harish.T.K