Data Movement and Integration
Also available as:
PDF
loading table of contents...

"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:

  1. Open the file.

    vi -b [filename]

  2. Type the password into the file.

  3. Set the option to eliminate the end-of-line bit.

    :set noeol

  4. Close the file.

    :wq