Sqoop list tables
list-tables
This chapter describes how to list out the tables of a particular database in MySQL database server using Sqoop.
Sqoop list-tables tool parses and executes the ‘SHOW TABLES’ query against a particular database.
Thereafter, it lists out the present tables in a database.
Syntax
The following syntax is used for Sqoop list-tables command.
$ sqoop list-tables (generic-args) (list-tables-args)
Sample Query
The following command is used to list all the tables in the userdb database of MySQL database server.
$ sqoop list-tables \
–connect jdbc:mysql://localhost/userdb \
–username root
