You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hbase.apache.org by "Kayla Fisher (JIRA)" <ji...@apache.org> on 2017/11/17 07:40:00 UTC

[jira] [Created] (HBASE-19292) Numerical comparison support for column value - cell

Kayla Fisher created HBASE-19292:
------------------------------------

             Summary: Numerical comparison support for column value - cell
                 Key: HBASE-19292
                 URL: https://issues.apache.org/jira/browse/HBASE-19292
             Project: HBase
          Issue Type: Wish
          Components: Filters
    Affects Versions: 1.3.1
         Environment: may not be related
            Reporter: Kayla Fisher


I've gotten the following data set:

rowkey1 test:duration =43425
rowkey2 test:duration = 5000
rowkey3 test:duration = 90
rowkey4 test:duration =8882
According to your filter languages, if i want the data in a specific duration range,e.g. 2000<duration<10000. I should compose the scanner specifications like this:
{FILTER => "SingleColumnValueFilter('test', 'duration', <=, 'binary:10000') AND SingleColumnValueFilter('test', 'duration', >=, 'binary:2000')"}
Finally got nothing, since i foud out that the comparator i used is BinaryComparator which compares by bits i.e, `90` is greater than `800`, a little incredible. 
Currently i am unable to follow your spectacular project in java, could you please add support for numerical comparison or give some advice to conform my needs.




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)