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 <[email protected]> wrote: > Hi All does anybody know how to import data from hbase table as tsv file. >
