sqoop import --verbose --connect jdbc:db2://hostname:5300/db --username username --password password --call NameStoredProcedure -m 1 --target-dir /tmp/DeltaY0/
How do we import more than one table in sqoop, lets say i have two table one is employee and other one is department and both are having primary-foreign key constraints , i want to import some columns from employee table and some from department based on primary-foreign key.
1) import all the data (it's called big data for a reason)
2) create a View in your RDBS and sqoop will treat that like a table.
for this requirment you can write join quiry withing sqoop import statement..coz of this u can import only required data in hadoop ecosystem.