21 comments
:

BTW, I'm experimenting HBase 0.19.1 using HTable and IndexedTable with filter, for both of these I am using ColumnValueFilter.

As you have mentioned in this post, I have an IndexedTable with 3 indexes.

I'm using getIndexedScanner method to read data from IndexedTable, and getScanner method to read from HTable. Inserted the same dataset (3.5 millions of records, each has 1 family and 12 qualifiers) into both of the tables.

But, what I wonder is I'm not getting any improved performance using IndexedTable than HTable.

What i notice is, on these following statement execution with IndexedTable, it takes more time than HTable

I'm not sure if this is just my machine, but the value for hbase.regionserver.impl wraps which doesn't actually work in the config files. You need to put it all on one line. Took me a while to figure out what was happening.

Good work rajeev. I believe the classes are in the contrib section of the distribution if you get hbase from the svn repository. you'll have to build the jar with the ant build and add it to you hbase class path. hope that helps. -checkwriter

Thanks for this help. I was able to add indexing to a existing table and it created another table. Now the problem I am having is that I am unable to add the data to the table. Can you please advise me in what to do. Thank you.

I also wanted to thank you for this example. I was able to get it to work with HBase version 0.20.6. Let me know if you would like me to send you my updated version of SecondaryIndexTest or I can post it to my blog with your permission and credit.

Rajeev, thanks again for this example. It was very helpful. I have been able to update and run the example with HBase Version: 0.20.6, r965666, on Linux. Let me know if you wish me to post the updated version.

Hi Paul, thanks for updating the code for the newer version. I couldn't find a way to reach you directly. I would love to put your code on my blogs if that fine with you. Also, Please do add the code to your blog as well.

Have you implemented secondary index with Hadoop map-reduce in Hbase 0.90? and Second I need to insert data into multiple tables by method bulk import using one map-reduce job.? Can you share your thoughts about it?

About Me

I am a technology enthusiast with 9+ years of experience in software
development. I have worked on multiple platforms, technologies and
domains in my career. I love to read about
upcoming technologies and trends in various domains. Currently, I am
exploring the world of mobile and web apps and working on pet projects
around html5, no-sql and video streaming.