with the following command sqoop job is running fine but while executing getting invalid username or password(both are correct)

[#1]

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

[#2]

@Naveen Kumar

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

.

[#3]

hi jay, thanks for reply.Checked and password is correct.