Need to find details searched through Column Values.

[#1]

Hi,

I have a very odd requirement to find out the details,but the search will have to be through Column values.

I can't use rowkey for the same.Tried using scan but it does takes lot of time as my records will be in billions.

Another way i found out is Secondary Indexing (Composite Index) ,but looking for something which is less time consuming.

Appreciate your valuable suggestions.

Thanks,

Debasish

[#2]

@Lester Martin

[#3]

Can you provide a very simple, but indicative, example of what you are looking for? Maybe a few rows and details of what you would be looking for. As you already know, the filter language documented at https://hbase.apache.org/book.html#thrift.filter_language will end up scanning everything. And also as you know, creating another table whose rowkey is aligned with your query you want to run fast will take effort to keep in sync as you upsert your data. There's always Phoenix is you want to stay completely in HBase, but maybe a hybrid of HBase and Solr might work. Again, my a simplified example could help.