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