I have configured sqoop-site.xml to record passwords and am running my sqoop jobs through oozie. Yet only some of the sqoop jobs out of all fail with the error:
- Error executing statement: java.sql.SQLException: Access denied for user 'root'@'10.10.10.9' (using password: NO)
How could that be? If passwords are recorded, why would it say (using password :NO) and why would only few of the jobs would fail?
I delete the job and re-run it, it works fine but then after a couple of runs, same problem arises.Then if I try to run it from command line, it still asks password until I delete and recreate the job and thus the cycle repeats.
My sqoop jobs look like this:
sqoop job --meta-connect jdbc:hsqldb:hsql://FQDN:16000/sqoop --create SAMPLE_job -- import --connect 'jdbc:mysql://IP/DB?zeroDateTimeBehavior=convertToNull' --username USERNAME --password 'PASSWORD' --driver com.mysql.jdbc.Driver --table TABLE --incremental lastmodified --check-column FIELD --merge-key FIELD --split-by FIELD --hive-import --hive-overwrite --hive-database DBNAME