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

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" wrote: > Hi, >

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

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 *| an

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

I think you can implement your own filter that overrides this method: public void filterRow(List 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 wrote: > Forgot t

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

Forgot to mention: Hadoop 1.0.4 & HBase 0.94.2 On Wed, May 8, 2013 at 4:52 PM, Amit Sela 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 like: > > List

Get all rows that DON'T have certain qualifiers

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 ArrayList(2); Filter filter1 = new SingleColumnValueFilter(Bytes.toBytes("fam1"), Bytes.toBytes("VALUE1