Sqoop is a tool designed to transfer data between
relational database servers.
Sqoop ships with a help tool. To display a list of all available tools, type the follow command:
sqoop evaltools allows to quickly run simple SQL queries against a database and the results are printed to the console. This allows users to preview their import queries to ensure they import the data they expect.
Sqoop List Databases
List database schemas present on a server.
Sqoop List Tables
List table schemas present on a database.
sqoop importtool imports individual table from RDBMS to HDFS. Each row in a table is treated as a record in HDFS. All records are stored as text data in text files or as binary data in Avro and Sequence files. The default format is text data.
sqoop exporttool exports a set of files from HDFS back to an RDBMS. The files given as input to Sqoop contain records, which are called as rows in table. Those are read and parsed into a set of records and delimited with user-specified delimiter.
sqoop jobcreates and saves the import and export commands. It specifies parameters to identify and recall the saved job.
To see detailed environment setup steps, one can check the following link: [Big Data Experiment Environment Setup](Big Data Experiment Environment Setup)