1. Create a file containing the connection string information in your UNIX/Linux home directory:
--connect jdbc:postgresql://mypostgres.server.com:5432/mydatabase
--user hduser
--password 'password'
2 . Secure that file by changing the permissions to owner read-only
chmod 400
3. Modify the appropriate Sqoop jobs to use this file
sqoop import --table mytable --options-file pg.parms
No comments:
Post a Comment