2)Sqoop Tools

Sqoop Tools:
Sqoop is a collection of related tools. To use Sqoop, we should specify the tool want to use and the arguments that control the tool.

Syntax:
sqoop tool-name [tool-arguments]
To display a list of all available sqoop tools:
Command:
sqoop help

Note:
Goodness is we can display the help for a specific tool by entering:
sqoop help (tool-name) or sqoop tool-name) --help

Example:
sqoop help import or sqoop import --help.


To perform the operation of each Sqoop tool:

mano@Mano:~$ sqoop import --help

usage: sqoop import [GENERIC-ARGS] [TOOL-ARGS]

So, the tool-arguments are divided into two categories

1. [GENERIC-ARGS}
2. [TOOL-ARGS]

1.[GENERIC-ARGS]==> These are controls the configuration and Hadoop server settings

Note:
comes after the tool name but before any tool-specific arguments (such as --connect,--username etc.,).
generic arguments are preceeded by a single dash character (-),

2.[TOOL-ARGS]==>These are related to sqoop tool which we use

Note:
tool-specific arguments start with two dashes (--), unless they are single character arguments such as -P.


Can be done through Options Files to Pass Arguments:

Step 1: Create a file on local storage area, which arguments options to pass for sqoop

Step 2: Pass the options file using --options_file argument

Syntax:
sqoop --options-file file_path;

Example:
I have used to inspect the database using eval tool

options_file.txt
#
# Options file for Sqoop import
#

eval

--connect
jdbc:mysql://localhost/sqoop_test

--username
root

--password
root

Execution:
Output:

Please follow the link for further ==>Sqoop_Page 3