166. List tables in MySql using “sqoop list-tables”

  • To get information on commands available with respect to list-tables command
    • sqoop help list-tables
  • Command to get list of tables in a database
    • sqoop list-tables --connect jdbc:sqlserver://hostname:port/database_name --username your_username --p
    • Example: sqoop list-tables --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user -p
    • -P in the above command will prompt for the password.

Share this post