RDMBS integration with Hadoop

Question

How do we integrate to Hadoop with rdbms?

Answer 1

About integrating RDBMS with Hadoop, you can use Sqoop. Look at the below example for the same:

Please follow the below steps to execute the sqoop import command.

Suppose there is a table in MySQL as below,

Now, we will import the data from this table to hdfs with the sqoop command.

sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/edureka --table student --username labuser -P --target-dir sqoop_stu1 -m 1

The output will be stored in hdfs in the directory named sqoop_stu1