86

Sqoop Export

In previous cases, flow of data was from RDBMs to HDFS. Using “export” tool, we can import data from HDFS to RDBMs. Before performing export, Sqoop fetches table metadata from MySQL database. Thus we first need to create a table with required metadata.

Table creation in MySQL

Export query is shown below:

Now, see output in MySQL by following code.