[jira] [Commented] (HBASE-10463) Filter on columns containing numerics yield wrong results

["Anoop Sam John (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HBASE-10463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13890515#comment-13890515 ] 

Anoop Sam John commented on HBASE-10463:
----------------------------------------

You can use the below constructor in SCVF?
{code}
public SingleColumnValueFilter(final byte [] family, final byte [] qualifier,
      final CompareOp compareOp, final WritableByteArrayComparable comparator) {
{code}
Instead of the BinaryComparator  you can make a comparator for the numeric values and use.

> Filter on columns containing numerics yield wrong results
> ---------------------------------------------------------
>
>                 Key: HBASE-10463
>                 URL: https://issues.apache.org/jira/browse/HBASE-10463
>             Project: HBase
>          Issue Type: Improvement
>          Components: Filters
>    Affects Versions: 0.94.8
>            Reporter: Deepa Vasanthkumar
>   Original Estimate: 168h
>  Remaining Estimate: 168h
>
> Used SingleColumnValueFilter with CompareFilter.CompareOp.GREATER_OR_EQUAL for filtering the scan result. 
> However the columns which have numeric value, scan result is not correct, because of lexicographic comparison.
> Does HBase support numeric value filters (for equal, greater or equal..) for columns ? If not, can we add it?



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)