Import a table from MySQL to Hbase using SQOOP Import

// Import into Hbase

sqoop import \

-connect jdbc:mysql://localhost:3306/ohm \

-driver com.mysql.jdbc.Driver \

-username root \

-password cloudera \

-table employee \

-hbase-create-table \

-hbase-table employee_details \

-column-family employees \

-hbase-row-key id -m 1

// single line statement for the same

sqoop import -connect jdbc:mysql://localhost:3306/ohm -driver com.mysql.jdbc.Driver -username root -password cloudera -table employee -hbase-create-table -hbase-table employee_details -column-family employees -hbase-row-key id -m 1

[cloudera@quickstart ~]$ hbase shell

scan 'employee-details'

// it will display all columnar view