Importing data from Hhbase to TSV file

[Jeetendra Gangele <ga...@gmail.com>]

Hi All does anybody know how to import data from hbase table as tsv file.

Re: Importing data from Hhbase to TSV file

[sandeep vura <sa...@gmail.com>]

Hi Jeetendra,

Add the below jar files in HBASE shell using the below command.

add jar hbase-0.94.17.jar;
add jar hbase-0.94.17-tests.jar;
add jar guava-11.0.2.jar;
add jar zookeeper-3.4.5.jar;
add jar protobuf-java-2.4.0a.jar;

The above jars are located in HBase lib directory.Later execute the below
command in HBase shell to import data as tsv file.

Example: ((Below is the example code,You need to do make changes as your
schema,and filenames.)

Note : Make sure load the input data into HDFS

hbase org.apache.hadoop.hbase.mapreduce.ImportTsv '-Dimporttsv.separator=,'
-Dimporttsv.columns=HBASE_ROW_KEY,location:s_borough,location:s_neighbor,location:s_b_class,location:s_c_p,location:s_block,location:s_lot,location:s_easement,location:w_c_p_2,location:s_address,location:s_app_num,location:s_zip,units:s_res_units,units:s_com_units,units:s_tot_units,size:s_sq_ft,size:s_g_sq_ft,age:s_yr_built,pricing:s_tax_c,pricing:s_b_class2,pricing:s_price,pricing:s_sales_dt
sales_data /user/data/salesdata/05_salesdata.csv

Regards,
Sandeep.v

On Thu, Apr 16, 2015 at 2:43 PM, Jeetendra Gangele <ga...@gmail.com>
wrote:

> Hi All does anybody know how to import data from hbase table as tsv file.
>