hbase get Rows only not null columns(Existing columns using condition)- in hbase table using java

Question

In hbase table I have 30 columns.example c1,c2,c3,c4......c30.and cf is column family. In one row I have c1 to c5 columns In some row c1,c3,c4,c6 ,c23 like that. So I want the rows only c2 and c3 are not null ,means these two column must exist in the row . if I use columnPrefix filter It is working only for one column but not more than one.Which filter can I use.Iam Using hbase 0.98.3 verion

Answer 1

You may want to give a try to MultipleColumnPrefixFilter. Check Below cloudera documentation for use.

http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/admin_hbase_filtering.html

Here is an another link with example.

http://www.hadooptpoint.com/filters-in-hbase-shell/