Sqoop list tables

Estimated reading: 1 minute 361 views

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

Leave a Comment

CONTENTS