Subsequent sections of this document explain how to specify these and other arguments to Sqoop. To use Sqoop, you specify the tool you want to use and the arguments that control the tool.
You can use Sqoop to import data from a relational database management system (RDBMS) such as My SQL or Oracle into the Hadoop Distributed File System (HDFS), transform the data in Hadoop Map Reduce, and then export the data back into an RDBMS.
Sqoop automates most of this process, relying on the database to describe the schema for the data to be imported.
These files may be delimited text files (for example, with commas or tabs separating each field), or binary Avro or Sequence Files containing serialized record data.
A by-product of the import process is a generated Java class which can encapsulate one row of the imported table.
You can specify particular delimiters and escape characters for the file-based representation of the data, as well as the file format used.