CREATE DATABASE library;

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‘);  

$ bin/sqoop import 
--connect jdbc:mysql://hadoop-senior01.itguigu.com:3306/db_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