Re: Get all rows that DON'T have certain qualifiers

2013-05-14 Thread samar.opensource
Hi, I will try to write a sample code and execute it , but what i gather from the blog and the java apidoc is that u just need to do opposite of what u r doing . so use CompareOp.|*EQUAL http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/CompareFilter.CompareOp.html#EQUAL*| and

Re: Get all rows that DON'T have certain qualifiers

2013-05-14 Thread James Taylor
Hi Amit, Using Phoenix, the SQL skin over HBase (https://github.com/forcedotcom/phoenix), you'd do this: select * from myTable where value1 is null or value2 is null Regards, James http://phoenix-hbase.blogspot.com @JamesPlusPlus On May 14, 2013, at 6:56 AM, samar.opensource

Get all rows that DON'T have certain qualifiers

2013-05-08 Thread Amit Sela
Hi all, I'm trying to scan my HBase table to get only rows that are missing some qualifiers. I read that for getting rows with specific qualifiers I should use something like: List list = new ArrayListFilter(2); Filter filter1 = new SingleColumnValueFilter(Bytes.toBytes(fam1),

Re: Get all rows that DON'T have certain qualifiers

2013-05-08 Thread Amit Sela
Forgot to mention: Hadoop 1.0.4 HBase 0.94.2 On Wed, May 8, 2013 at 4:52 PM, Amit Sela am...@infolinks.com wrote: Hi all, I'm trying to scan my HBase table to get only rows that are missing some qualifiers. I read that for getting rows with specific qualifiers I should use something

Re: Get all rows that DON'T have certain qualifiers

2013-05-08 Thread Ted Yu
I think you can implement your own filter that overrides this method: public void filterRow(ListKeyValue ignored) throws IOException { When certain qualifiers don't appear in the List, you can remove all the kvs from the passed List. Cheers On Wed, May 8, 2013 at 7:00 AM, Amit Sela