4.1 导入数据
4.1.1 RDBMS到HDFS
-
确定Mysql服务开启正常
-
在Mysql中新建一张表并插入一些数据
mysql -u root -p
create database company;
use company;
create table staff(id int(4) primary key not null auto_increment, name varchar(255), sex varchar(255));
insert into staff(name, sex) values(‘Thomas’, ‘Male’);
insert into staff(name, sex) values(‘Catalina’, ‘FeMale’); -
导入数据
(1)全部导入
sqoop import
–connect jdbc:mysql://127.0.0.1:3306/company
–username root
–password root
–table staff
–target-dir /user/company
–delete-target-dir
–num-mappers 1
–fields-terminated-by “\t”
(2)查询导入
sqoop import
–connect jdbc:mysql://127.0.0.1:3306/company
–username root
–password root
–target-dir /user/company
–delete-target-dir
–num-mappers 1
–fields-terminated-by “\t”
–query ‘se