Cloud Computing - Sqoop

Back to Course

Lesson Description

Lession - #804 Sqoop List Tables

This section portrays how to list off the tables of a specific information base in MySQL database server utilizing Sqoop. Sqoop list-tables device parses and executes the 'SHOW TABLES' inquiry against a specific information base. From there on, it lists down the current tables in an database.


Below is the syntax for sqoop list table command.
$ sqoop list-tables (generic-args>
$ sqoop-list-tables (generic-args>

Sample Query

The accompanying command is utilized to list every one of the tables in the userdb database of MySQL data set server.
$ sqoop list-tables \
--connect jdbc:mysql://localhost/userdb \
--username root
In the event that the command is executes effectively, it will show the list of tables in the userdb information base as follows.
13/05/31 16:45:58 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.