sqooping to hdfs from oracle DB
Job created susccessfully but while executing its showing an error invalid username or password.
sqoop job -Dmapred.job.queue.name=*** -Dorg.apache.sqoop.credentials.loader.class=org.apache.sqoop.util.password.CryptoFileLoader -Dorg.apache.sqoop.credentials.loader.crypto.passphrase=*** --create jobname -- import --connect ************ --password-file file:///tmp/pass.enc --username *** --table *** --check-column *** --incremental append --last-value *** --target-dir **** --split-by **** --verbose
sqoop job --exec jobname
Error:invalid username/password; logon denied
Thanks in advance
Sometimes it happens that the "--password-file" has some hidden characters (not visible in few editors) Hence please make sure that the password is present without unwanted hidden characters in it.
You can try generating the password file as following and then use it in your scoop command.
# echo -n "your_password" > /tmp/pass.enc
hi jay, thanks for reply.Checked and password is correct.