Sqoop list database

Estimated reading: 1 minute 819 views


This chapter describes how to list out the databases using Sqoop.
Sqoop list-databases tool parses and executes the ‘SHOW DATABASES’ query against the database server.

it lists out the present databases on the server.

The following syntax is used for Sqoop list-databases command.

$ sqoop-list-databases (generic-args) (list-databases-args)

Sample Query
The following command is used to list all the databases in the MySQL database server.


sqoop list-databases –connect jdbc:mysql://localhost:3306 –username root -P

If the command executes successfully, then it will display the list of databases in your MySQL database server as follows.

Leave a Comment

Share this Doc