Just a quick thought, why don't you create different tables and duplicate data i.e. go for demoralization and data redundancy. Is your all read access patterns that would require 70 columns are incorporated into one application/client? Or it will be bunch of different clients/applications? If that is not the case then I think why not take advantage of more storage.
Regards, Shahab On Tue, Jun 4, 2013 at 12:43 PM, Ramasubramanian Narayanan < ramasubramanian.naraya...@gmail.com> wrote: > Hi, > > In a HBASE table, there are 200 columns and the read pattern for diffferent > systems invols 70 columns... > In the above case, we cannot have 70 columns in the rowkey which will not > be a good design... > > Can you please suggest how to handle this problem? > Also can we do indexing in HBASE apart from rowkey? (something called > secondary index) > > regards, > Rams >
