How to use Password file with Sqoop

How to use local password-file parameter with sqoop Problem: sometimes we have to read password from file for sqoop command. Solution: Passing password parameter file to sqoop command is not a big deal. Just follow below steps: 1.    Create a password with Echo -n “<<password>> > <<passwordfilename>> E.g....

Read More

SQOOP-SqlManager-Error reading from database-java.sql.SQLException-set com.mysql.jdbc.RowDataDynamic-3c2d5cfb

Problem: sqoop export --connect "jdbc:mysql://sandbox.hortonworks.com:3306/hdpcdpractise" --username hadoop --password hadoop --table weather --export-dir /user/hortonworks/weather/  --fields-terminated-by ','; Some times...

Read More