Shortcomings of the HBase API : Unfortunately if a developer relies on the native "HBase API" for accessing the HBase tables, he would require to put in a lot of efforts to do so, as it provides a very restricted set of functions. 

So in an attempt to save all those extra efforts and enable easy handling of HBase tables this post adds another set of functions such as distinct, having, between, intersection, union to the API which work for HBase just as we have these working in SQL .

Original Post can be found here :

http://hbasecodes.blogspot.com/2011/01/operating-on-hbase-columns.html