Is there any way to load data from MySql to HDFS

Question

I have data present in MySql table. What I want is to import this data to HDFS. I found that there is a tool called Sqoop, used to import data from MySql but how to use Sqoop or how to write a command to load data from MySql to HDFS?

Can anyone please help me out??

Answer 1

The generic command i.e used to import data from MySql to HDFS is as shown in below image:

Now, to understand import function, let us take an example:

Suppose we have to import the given below table to HDFS. 

So the command for importing this table to HDFS will be:

sqoop import --connect jdbc:mysql://sqoopdb.edu.cloudlab.com/userdb --username labuser --password edureka --table emp –m 1 --target-dir ‘/user/edureka_249489/sqoop_sql/’;

I hope this will give you some idea about how to import data from MySql to HDFS.