CODEWITHSUNDEEP
hadoophbase
mikeL
mikeL

Reputation: 1114

creating base table with multiple column families

I am new to hbase. I am using HBase version 1.1.2 on Microsoft Azure. I have data that looks like this

id  num1  rating
 1   254      2
 2    40      3
 3    83      1
 4   120      1
 5    91      5
 6   101      2
 7    17      1
 8    10      2
 9    11      3
10    31      1

I tried to create a table with two colum families of the form

create 'table1', 'family1', 'family2'

when I loaded my table 

hbase org.apache.hadoop.hbase.mapreduce.ImportTsv \
-Dimporttsv.columns="HBASE_ROW_KEY,family1:num1, family2:rating" table1 /metric.csv

I got the error

Error: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed 5560 actions: org.apache.hadoop.hbase.regionserver.NoSuchColumnFamilyException: Column family family2 does not exist in region table1

when I modified my table with one column family it worked

create 'table1', 'family1'



hbase org.apache.hadoop.hbase.mapreduce.ImportTsv \
-Dimporttsv.columns="HBASE_ROW_KEY,family1:num1, family1:rating" table1 /metric.csv

How do I adjust my table creation to account for multiple column families?

Upvotes: 0

Views: 962

Answers (1)

Venkata Sudheer Kumar M
Venkata Sudheer Kumar M

Reputation: 109

HBase ImportTsv internally uses PUT operations to load the data into HBase tables.

PUT only supports loading into single column family at a time Here Here and from Documentation

Upvotes: 0

Related Questions