Sqoop Import --password-file function not working properly in sqoop 1.4.4 Sqoop Import --password-file function not working properly in sqoop 1.4.4 hadoop hadoop

Sqoop Import --password-file function not working properly in sqoop 1.4.4


"\n" is being written in file when you vi the file and write the password.Better use the below approach to avoid problems

echo -n "Your_sqoop_password" > sqoop.password


Not sure if you are still having this issue. The password file can be in any folder. Try the following syntax and it should work:

--password-file file:///user/root/database.password


As per the sqoop documentation

You should save the password in a file on the users home directory with 400 permissions and specify the path to that file using the --password-file argument, and is the preferred method of entering credentials. Sqoop will then read the password from the file and pass it to the MapReduce cluster using secure means with out exposing the password in the job configuration. The file containing the password can either be on the Local FS or HDFS.

If I am running my sqoop job with root user then my password file will be in /user/root/ in HDFS

sqoop import --connect jdbc:mysql://database.example.com/employees \    --username venkatesh --password-file /user/root/database.password

For more details you can check this