Sqoop List Databases – Syntax and Arguments

1. Objective

In Sqoop, there is a tool that executes as well as parses the ‘SHOW DATABASES’ query against the database server. Basically, that we call Sqoop list databases tool. This chapter carries information on how to list out the databases using Sqoop. Apart from an introduction of Sqoop list-databases, we will also describe purpose & syntax of Sqoop list databases, to learn well. Also, we will cover its examples for deep understanding.

Sqoop List Databases

Sqoop List Databases – Introduction

2. Introduction to Sqoop List Databases

a. Basically, Sqoop list-databases tool executes as well as parses the SHOW DATABASES’ query against the database server.
b. Also, it lists out the present databases on the server.

Get the most demanding skills of IT Industry - Learn Hadoop

3. Purpose of Sqoop List-Databases tool

Although, the main purpose of Sqoop list databases tool is it lists out the present on a server.

4. Syntax to Sqoop List Databases

$ sqoop list-databases (generic-args) (list-databases-args)
$ sqoop-list-databases (generic-args) (list-databases-args)
However, the list-databases arguments can be entered in any order with respect to one another, but the Hadoop generic arguments must precede any Sqoop list-databases arguments only.

5. Common Arguments for Sqoop List Databases

ArgumentDescription
–connect <jdbc-uri>Specify JDBC connect string
–connection-manager <class-name>Specify connection manager class to use
–driver <class-name>Manually specify JDBC driver class to use
–hadoop-mapred-home <dir>Override $HADOOP_MAPRED_HOME
–helpPrint usage instructions
–password-fileSet path for a file containing the authentication password
-PRead password from console
–password <password>Set authentication password
–username <username>Set authentication username
–verbosePrint more information while working
–connection-param-file <filename>Optional properties file that provides connection parameters
–relaxed-isolationSet connection transaction isolation to read uncommitted for the mappers.
Hadoop Quiz

6. Sqoop List Databases Example Invocations

Basically, here, on a MySQL server, sqoop list database schemas available:
$ sqoop list-databases –connect jdbc:mysql://database.example.com/
information_schema
Employees
Also, note that it only works with HSQLDB, MySQL, and Oracle. However, it is necessary that the user connecting to the database has DBA privileges while using with Oracle.

7. Conclusion

As a result, we have seen the complete introduction of Sqoop List Databases tool. Also, we have seen its syntax as well as purpose. Moreover, we have covered list databases arguments in sqoop for practical uses. Although if any query regarding same strikes you, please ask through the comment section.
See Also-
Sqoop Import and Sqoop Validation
For reference

Leave a Reply

Your email address will not be published. Required fields are marked *