Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> filtering rows for column values not null


Copy link to this message
-
Re: filtering rows for column values not null
yes! that was exactly what I was looking for.

thanks.
Ted

On 10/24/13, Toby Lazar <[EMAIL PROTECTED]> wrote:
> I think Ted is looking for the SingleColumnValueFilter.setFilterIfMissing()
> method.  Try setting that to true.
>
> Toby
>
> *******************************
>   Toby Lazar
>   Capital Technology Group
>   Email: [EMAIL PROTECTED]
>   Mobile: 646-469-5865
> *******************************
>
>
> On Thu, Oct 24, 2013 at 9:23 AM, Jean-Marc Spaggiari <
> [EMAIL PROTECTED]> wrote:
>
>> Hi Ted,
>>
>> I'm not sure to get you. HBase will not store any cell in the system if
>> there is no content. So if you do a scan, you will get only the cells
>> where
>> the content is not null. There is no need to have any filter here. Can
>> you
>> please detail what you put in the table and what cells you are trying to
>> NOT read?
>>
>> JM
>>
>>
>> 2013/10/24 Ted <[EMAIL PROTECTED]>
>>
>> > Hi I have a relatively simple situation,
>> >
>> > As an example I have a table of Users, with first and last name.
>> >
>> > I set a scan a FilterList and I add a SingleColumnValueFilter, with
>> > column qualifier=firstName, CompareOp.EQUAL, and value="bob".
>> >
>> > The problem is, I'm getting "bob" as well as anyone with out a
>> > firstName.
>> >
>> > I tried adding NOT_EQUALS null and NOT_EQUALS (new byte[0]) and neither
>> > helped.
>> >
>> > Does anyone know of how to filter on a column value not null?
>> > --
>> > Ted.
>> >
>>
>
--
Ted.
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB