satya - 7/14/2019, 12:20:03 PM

Briefly

Sqoop - SQL to Hadoop

Used to load data from relational databases in parallel to HDFS using Map/Reduce framework underneath

Multiple workers will load data from multiple machines into an HDFS cluster.

You can also load data from HDFS to a relational database

satya - 7/14/2019, 12:21:07 PM

List of Sqoop Commands

Search for: List of Sqoop Commands

satya - 7/14/2019, 12:22:57 PM

Here is SQOOP user guide

satya - 7/14/2019, 12:25:07 PM

Commands of Sqoop


$ sqoop help
usage: sqoop COMMAND [ARGS]

Available commands:
  codegen            Generate code to interact with database records
  create-hive-table  Import a table definition into Hive
  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
  list-databases     List available databases on a server
  list-tables        List available tables in a database
  version            Display version information