Databases Reference
In-Depth Information
TOOL
indicates the operation that you want to perform. The most important operations
are
import
for transferring data from a database to Hadoop and
export
for transferring
data from Hadoop to a database.
PROPERTY_ARGS
are a special set of parameters that are
entered as Java properties in the format
-Dname=value
(examples appear later in the
topic). Property parameters are followed by
SQOOP_ARGS
that contain all the various
Sqoop parameters.
Mixing property and Sqoop parameters together is not allowed. Fur‐
thermore, all property parameters must precede all Sqoop parameters.
You can specify
EXTRA_ARGS
for specialized connectors, which can be used to enter
additional parameters specific to each connector. The
EXTRA_ARGS
parameters must be
separated from the
SQOOP_ARGS
with a
--
.
Sqoop has a bewildering number of command-line parameters (more
than 60). Type
sqoop help
to retrieve the entire list. Type
sqoop help
TOO
(e.g.,
sqoop help import
) to get detailed information for a spe‐
cific tool.
1.5. Getting Help with Sqoop
Problem
You have a question that is not answered by this topic.
Solution
You can ask for help from the Sqoop community via the mailing lists. The
Sqoop Mailing
Lists page
contains general information and instructions for using the Sqoop User and
Development mailing lists. Here is an outline of the general process:
1. First, you need to subscribe to the User list at the Sqoop Mailing Lists page.
2. To get the most out of the Sqoop mailing lists, you may want to read Eric Raymond's
