Sqoop Import

We have tables in mySql database and we have to import it to HDFS using Sqoop.To see the content in a table type the below command in mySql prompt.

Importing "countries" table into our HDFS environment:

Type above command in a single line.

Here -m 1 specifies one mapper for each table. All the tables are downloaded indefault directory.The default number of mappers used is 4. You can change this by appending the command by "-m number_of_mappers".