SQOOP setup

Install SQOOP in the node from where you want to connect

#rpm -ivh /sqoop-1.4.2_2_0_1_0-nn.noarch.rpm

Check the conenctivity  to remote database server.

#psql -h -p 10432 -U user1 -d db1 -W

If the above works try listing the database using sqoop

[root@server sqoop]# sqoop list-databases –connect jdbc:postgresql:// –username user1 -P

Enter password:
13/11/05 04:38:50 INFO manager.SqlManager: Using default fetchSize of 1000

If the listing is scucessfull go for the import

#sqoop import –connect jdbc:postgresql:// –username user1 -P –table TBLS –as-textfile –target-dir /user/user1/sqoop1
Enter password:

We can copy the JDBC drivers to sqoop lib for connectivity.

#cp postgresql-8.2-1002.jdbc4.jar /usr/lib/sqoop/lib



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s