sqoop将RDBMS中的数据抽取到HBase中

配置sqoop

准备工作,在MySQL创建表数据

CREATE TABLE book(
id int(4) PRIMARY KEY NOT NULL AUTO_INCREMENT, 
name VARCHAR(255) NOT NULL, 
price VARCHAR(255) NOT NULL);

INSERT INTO book(name, price) VALUES('Lie Sporting', '30');  
INSERT INTO book (name, price) VALUES('Pride & Prejudice', '70');  
INSERT INTO book (name, price) VALUES('Fall of Giants', '50');

执行Sqoop导入hbase数据的操作

 bin/sqoop import \
--connect jdbc:mysql://hadoop-senior01.buba.com:3306/library \
--username root \
--password 123456 \
--table book \
--columns "id,name,price" \
--column-family "info" \
--hbase-create-table \
--hbase-row-key "id" \
--hbase-table "hbase_book" \
--num-mappers 1  \
--split-by id;