List tables in MySQL using "sqoop list-tables"

#1

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://ms.itversity.com:3306/retail_db" \
  --username retail_user \
  --password itversity
0 Likes