本节主要内容:用sqoop进行Mysql到HDFS的导入导出
一、准备数据
数据准备(Node3节点)
在mysql中建立sqoop_test库
# mysql -uroot -p123456mysql> create database sqoop_test;
Query OK, 1 row affected (0.00 sec)
在sqoop_test里面建立一个表mysql> use sqoop_test;
Database changed
mysql> CREATE TABLE `student_sqoop` (
-> `id` int(11) NOT NULL,
-> `name` varchar(20) NOT NULL,
-> PRIMARY KEY (`id`)
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.04 sec)
插入数据mysql> insert into student_sqoop (id,name) values (1,'michael');
mysql> insert into student_sqoop (id,name) values (2,'ted');
mysql> insert into student_sqoop (id,name) values (3,'jack');
二、导入mysql到hdfs
为了测试,mysql配置权限(Node3节点)mysql> grant all privileges on *.* to