Using sqoop in DB2 data extraction

Hi,

There are 500+ tables with huge data in my client DB2 database.
They wants them to available in

  1. as individual csv file
  2. their HDFS

I am planning to use sqoop import here for both the requirements. Is it fine? If yes how can we write a single job to execute for all 500+ tables?

Please advice.

1 Like