Sqoop Import Loading HBase case

Simply write the steps to sqoop the order table into the HBase table.

The following table:

1. Open HBase through the hbase shell.

2. Create an HBase table

Create '  So ','o'

3. Import the data of so table into HBase.

Opt file:

--connect: Database

--username: Database user name

--password: Database Password

--table: Tables that need to be sqoop

--columns: Columns in a table

Table in the--hbase-table:hbase

--column-family: Column Family

--hbase-row-key: Specify Rowkey

Import--ConnectJdbc:mysql://192.168.2.115:3306/Test--usernameRoot--Password123456-m1--null-string"'--Table So--Columns"Date,order_id,user_id, Order_amt,order_id_new "--hbase-table So--column-familyo--Hbase-row-keyOrder_id_new

Execution: Sqoop--options-file./so_hbase.opt

Sqoop Import Loading HBase case