Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

New Contributor

sqooping to hdfs from oracle DB

Job created susccessfully but while executing its showing an error invalid username or password.

sqoop job*** -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


Super Mentor

@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


New Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.