Sqoop CLI

Contents

Overview

This section includes the reference documentation for the Sqoop CLI shell. All Sqoop commands are invoked by the bin/sqoop script.

The Sqoop shell usage is as follows:

$ sqoop COMMAND [<GENERIC_OPTIONS>] [<SPECIFIC_OPTIONS>]

where <GENERIC_OPTIONS> are preceeded by a single dash character (-). <SPECIFIC_OPTIONS> start with two dashes (--), unless they are single character arguments.

Commands

Sqoop provides the following tools.

Generates Java classes that encapsulate and interpret imported records

Populates a Hive metastore with a definition for a table based on a database table previously imported to HDFS, or one planned to be imported

Allows users to quickly run simple SQL queries against a database; results are printed to the console

Exports a set of files from HDFS back to an RDBMS

Lists tools available in Sqoop and explains their usage

Imports a set of tables from an RDBMS to HDFS

Imports all sequential datasets in a partitioned dataset (PDS) on a mainframe to HDFS

Imports an individual table from an RDBMS to HDFS

Allows you to create and work with saved jobs

Lists database schemas present on a server

Lists tables present in a database

Allows you to combine two datasets where entries in one dataset should overwrite entries of an older dataset

Configures Sqoop to host a shared metadata repository

Displays version information for Sqoop

Found a mistake? Seleсt text and press Ctrl+Enter to report it