- 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.
Durga Gadiraju
166. List tables in MySql using “sqoop list-tables”
- March 16, 2023
- , 6:08 am
- , Uncategorized