{"id":369,"date":"2019-02-24T06:29:17","date_gmt":"2019-02-24T06:29:17","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=369"},"modified":"2024-04-06T12:11:38","modified_gmt":"2024-04-06T12:11:38","slug":"import-and-export-data-with-sqoop-in-hdfs","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/hadoop\/sqoop\/import-and-export-data-with-sqoop-in-hdfs\/","title":{"rendered":"Import and export data with Sqoop in HDFS"},"content":{"rendered":"

Import and Export Data with Sqoop in HDFS<\/h2>\n

 <\/p>\n

Import and export data with Sqoop in HDFS<\/strong>, Welcome to the world of advanced Tutorials on Hadoop technology<\/a>. Are you looking forward to How to Import Data from MySQL to HDFS using sqoop?<\/p>\n

 <\/p>\n

There are many possible ways to Import and export data with Sqoop in HDFS, just follow the below-mentioned step by step process of How to import and export data from MySQL to HDFS using Sqoop tutorials which was originally designed by India\u2019s Leading Hadoop Training institute<\/a> Professionals who also offering advanced Hadoop Course<\/a> and Certification Programs.<\/p>\n

 <\/p>\n

Import data from MySQL to HDFS using Sqoop<\/h2>\n

 <\/p>\n

Install mysql on your machine,open terminal after\u00a0open the terminal it asking for password enter password as root.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Create database by using below command.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Use your created database use below command.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Create table .<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Insert values into created table.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

If you want to see the inserted data use below query.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Go to below link and download mysql-connector-java-5.1.26-bin.jar, link<\/a> and put on cloudera desktop .<\/p>\n

 <\/p>\n

Copy mysql connector jar into sqoop using below command.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Password is cloudera<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

You can check weather jar file is copied sqoop\/lib or not using below command.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

To check the IP address of your machine open machine command prompt and type below command.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

In MySQL\u00a0command prompt grant all privileges\u00a0to IP address of VMnet1 by using below command.<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Import data from mysql to sqoop<\/h3>\n

 <\/p>\n

Using below syntax :\u00a0Sqoop\/bin$ sqoop import –connect jdbc:mysql:ipaddress\/databasename<\/p>\n

–table <tablename> –username <username of mysql> \u2013P –target-dir \/dirname -m 1<\/p>\n

\"Import<\/p>\n

 <\/p>\n

EnterPassword: root<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

To check output : Open browser and go to \/usr\/sqoopOut\/part-m-00000<\/p>\n

 <\/p>\n

\"Import<\/p>\n

 <\/p>\n

Export Data from HDFS to MySQL using Sqoop<\/h2>\n

 <\/p>\n

Create table in mysql<\/p>\n

 <\/p>\n

\"Export<\/p>\n

 <\/p>\n

Use below command for export data from hdfs to mysql<\/p>\n

 <\/p>\n

Syntax:\u00a0Sqoop\/bin$ sqoop export –connect jdbc:\/\/ipaddress\/databasename –username username –password password –table tablename –export-dir \/dirname<\/p>\n

 <\/p>\n

\"Export<\/p>\n

 <\/p>\n

To check data where data exported use below query<\/p>\n

 <\/p>\n

\"Export<\/p>\n

Get success in your career as a Hadoop developer<\/a> by being a part of the Prwatech<\/a>, India’s leading Hadoop training institute in Bangalore<\/a>.<\/p>\n

 <\/p>\n