Using Sqoop to extract data between a relational database and Hadoop

(i) importing from a relational database to HDFs

1. Keep the following parameters as Import.script

Import

--connect
Jdbc:mysql://192.168.1.14:3306/test
--username
Root
--password
1234

-M
1
--null-string
‘‘
--table
User
--columns
"Id,username,age"
--target-dir
/user/root/sqoop_test--This directory cannot exist

2. Execute Sqoop--options-file./import.script

(ii) Import from HDFs to a relational database

1. Keep the following parameters as Export.script

Export
--connect
Jdbc:mysql://192.168.1.14:3306/test
--username
Root
--password
1234

--null-string
‘‘
--table
User
--columns
"Id,username,age"
--export-dir
/user/root/sqoop_test

2. Execute Sqoop--options-file./import.script

Using Sqoop to extract data between a relational database and Hadoop