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.
who want to use the Navigation Function Explorer, you can go here. open file explorer windows 10 , in this Explorer, you can get the feature and you can open more tabs at a time so that your work can be done faster
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.