1.

How Can You Avoid Importing Tables One-by-one When Importing A Large Number Of Tables From A Database?

Answer»

USING the command

sqoop IMPORT-all-tables

  1. CONNECT
  2. usrename
  3. PASSWORD
  4. exclude-tables table1,table2 ..

This will import all the tables EXCEPT the ones mentioned in the exclude-tables clause.

Using the command

sqoop import-all-tables

This will import all the tables except the ones mentioned in the exclude-tables clause.



Discussion

No Comment Found