Database Reference
In-Depth Information
eval Evaluate a SQL statement and display the results
export Export an HDFS directory to a database table
help List available commands
import Import a table from a database to HDFS
import-all-tables Import tables from a database to HDFS
job Work with saved jobs
list-databases List available databases on a server
list-tables List available tables in a database
merge Merge results of incremental imports
metastore Run a standalone Sqoop metastore
version Display version information
See 'sqoop help COMMAND' for information on a specific command.
As it explains, the
help
tool can also provide specific usage instructions on a particular
tool when you provide that tool's name as an argument:
%
sqoop help import
usage: sqoop import [GENERIC-ARGS] [TOOL-ARGS]
Common arguments:
--connect <jdbc-uri> Specify JDBC connect string
--driver <class-name> Manually specify JDBC driver class to use
--hadoop-home <dir> Override $HADOOP_HOME
--help Print usage instructions
-P Read password from console
--password <password> Set authentication password
--username <username> Set authentication username
--verbose Print more information while working
...
An alternate way of running a Sqoop tool is to use a tool-specific script. This script will
be named sqoop-
toolname
(e.g., sqoop-help, sqoop-import, etc.). Running these scripts
from the command line is identical to running
sqoop help
or
sqoop import
.
