List tables in MySQL using "sqoop list-tables"


Let us see how to list tables using Sqoop in a Database setup in MySQL.

  • To list tables, we need to specify database name as part of JDBC URI.
  • It will list the tables that exists in the underlying MySQL Server in case of MySQL.
sqoop list-tables \
  --connect "jdbc:mysql://" \
  --username retail_user \
  --password itversity