Re: HBase Negation or NOT operator
Thanks Vladimir. Jean-Daniel my use-case is very similar to Phoenix. We have our own small search query syntax to which I have to write a converter to both SOLR and HBase. You are right about scaling. I am new to HBase and starting with filter implementation. We also want to have a MapReduce later. Thanks, Ashwin On Tue, Sep 17, 2013 at 9:38 PM, Vladimir Rodionov vrodio...@carrieriq.comwrote: https://github.com/forcedotcom/phoenix to your help. It is worth taking a look at least. Best regards, Vladimir Rodionov Principal Platform Engineer Carrier IQ, www.carrieriq.com e-mail: vrodio...@carrieriq.com From: Ashwin Jain [ashvyn.j...@gmail.com] Sent: Tuesday, September 17, 2013 1:34 AM To: user@hbase.apache.org Subject: HBase Negation or NOT operator Hello All, Does HBase not support an SQL NOT operator on complex filters? I would like to filter out whatever matches a complex nested filter. my use case is to parse a query like this(below) and build a HBase filter from it. (field1=value1 AND NOT ((field2=value2 OR field3=value3) AND field4=value4)) How to go about this , any ideas? What will be a better approach - implement a custom filter that excludes a row qualified by another filter or to convert input query into an opposite query. Thanks, Ashwin Confidentiality Notice: The information contained in this message, including any attachments hereto, may be confidential and is intended to be read only by the individual or entity to whom this message is addressed. If the reader of this message is not the intended recipient or an agent or designee of the intended recipient, please note that any review, use, disclosure or distribution of this message or its attachments, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and/or notificati...@carrieriq.com and delete or destroy any copy of this message and its attachments.
HBase Negation or NOT operator
Hello All, Does HBase not support an SQL NOT operator on complex filters? I would like to filter out whatever matches a complex nested filter. my use case is to parse a query like this(below) and build a HBase filter from it. (field1=value1 AND NOT ((field2=value2 OR field3=value3) AND field4=value4)) How to go about this , any ideas? What will be a better approach - implement a custom filter that excludes a row qualified by another filter or to convert input query into an opposite query. Thanks, Ashwin
RE: HBase Negation or NOT operator
https://github.com/forcedotcom/phoenix to your help. It is worth taking a look at least. Best regards, Vladimir Rodionov Principal Platform Engineer Carrier IQ, www.carrieriq.com e-mail: vrodio...@carrieriq.com From: Ashwin Jain [ashvyn.j...@gmail.com] Sent: Tuesday, September 17, 2013 1:34 AM To: user@hbase.apache.org Subject: HBase Negation or NOT operator Hello All, Does HBase not support an SQL NOT operator on complex filters? I would like to filter out whatever matches a complex nested filter. my use case is to parse a query like this(below) and build a HBase filter from it. (field1=value1 AND NOT ((field2=value2 OR field3=value3) AND field4=value4)) How to go about this , any ideas? What will be a better approach - implement a custom filter that excludes a row qualified by another filter or to convert input query into an opposite query. Thanks, Ashwin Confidentiality Notice: The information contained in this message, including any attachments hereto, may be confidential and is intended to be read only by the individual or entity to whom this message is addressed. If the reader of this message is not the intended recipient or an agent or designee of the intended recipient, please note that any review, use, disclosure or distribution of this message or its attachments, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and/or notificati...@carrieriq.com and delete or destroy any copy of this message and its attachments.
Re: HBase Negation or NOT operator
You can always remove the NOT clause by changing the statement, but I'm wondering what your use case really is. HBase doesn't have secondary indexes so, unless you are doing a short-ish scan (let's say a million rows), it means you want to do a full table scan and that doesn't scale. J-D On Tue, Sep 17, 2013 at 1:34 AM, Ashwin Jain ashvyn.j...@gmail.com wrote: Hello All, Does HBase not support an SQL NOT operator on complex filters? I would like to filter out whatever matches a complex nested filter. my use case is to parse a query like this(below) and build a HBase filter from it. (field1=value1 AND NOT ((field2=value2 OR field3=value3) AND field4=value4)) How to go about this , any ideas? What will be a better approach - implement a custom filter that excludes a row qualified by another filter or to convert input query into an opposite query. Thanks, Ashwin