"Can't find the file" Error when Using a Password File
If you get an error that states "Can't find the file" when using the --password-file option with Sqoop, you might need to remove nonvisible content from the password file. Some text editors add bits to the file that cause the data export or import job to fail.
For example, by default VI and VIM add a single bit at the end of a line. To prevent the extra bit from being added, do the following:
Open the file.
vi -b[filename]Type the password into the file.
Set the option to eliminate the end-of-line bit.
:set noeolClose the file.
:wq