How to import data to hbase database

Question

I have a CSV file having data. how to this data to HBase? How it is if I want to upload data to one column family or to multiple column families? or else if not CSV file which type of data file(i mean data format ) is needed to import to HBase? if there provide me with the sample?

Answer 1

First you have to have the file in hdfs. 

Then there 3 Ways to Load Data From HDFS to HBase

1.Using ImportTsv to load txt to HBase

a) Create table in hbase

command：

create ‘tab3′,’cf’

b) Uploading simple1.txt to HDFS

command：

bin/hadoop fs -copyFromLocal simple1.txt  /user/hadoop/simple1.txt

The context in the txt is:

1,tom
2,sam
3,jerry
4,marry
5,john

c) Using ImportTsv to load txt to HBase

command：

bin/hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=”,”

-Dimporttsv.columns=HBASE_ROW_KEY,cf tab4 /user/hadoop/simple1.txt

ImportTsv execute result:

2.Using completebulkload to load txt to HBase

a) creating table in hbase

command：

create ‘hbase-tb1-003′,’cf’

b) Using ImportTsv to generate HFile for txt in HDFS

command：

bin/hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=”,” 
-Dimporttsv.bulk.output=hfile_tmp5 -Dimporttsv.columns=HBASE_ROW_KEY,cf hbase-tbl-003 /user/hadoop/simple1.txt

This command will be executed by MapReduce job:

As a result, the Hfile hfile_tmp5 is generated.

But the data wasn’t loaded into the Hbase table: hbase-tb1-003.

3.Using completebulkload to load Hfile to HBase

command: 

hadoop jar lib/hbase-server-0.98.13-hadoop2.jar completebulkload hfile_tmp5 hbase-tbl-003

Result: