hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kayla Fisher (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HBASE-19292) Numerical comparison support for column value - cell
Date Fri, 17 Nov 2017 07:43:00 GMT

     [ https://issues.apache.org/jira/browse/HBASE-19292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kayla Fisher updated HBASE-19292:
---------------------------------
    Description: 
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. I have read your source code of
the BinaryComparator, it's really vague for newbie in java.
Could you please add support for numerical comparison or give some advice to conform my needs.


  was:
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.



> 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
>              Labels: patch
>   Original Estimate: 336h
>  Remaining Estimate: 336h
>
> 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. I have read your source code
of the BinaryComparator, it's really vague for newbie 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)

Mime
View raw message