hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Charles (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HBASE-3729) Get cells via shell with a time range predicate
Date Tue, 05 Apr 2011 06:34:05 GMT

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

Eric Charles commented on HBASE-3729:
-------------------------------------

Right, get.rb was there.
I applied patch and tested with 

hbase(main):001:0> create 'test', 'cf'
hbase(main):003:0> put 'test', 'row1', 'cf:a', 'value1'
hbase(main):004:0> scan 'test'
ROW                                              COLUMN+CELL
 row1                                            column=cf:a, timestamp=1301984830139, value=value1
==> value1 ==> OK
1 row(s) in 0.0440 seconds
hbase(main):005:0> put 'test', 'row1', 'cf:a', 'value2'
0 row(s) in 0.0610 seconds
hbase(main):006:0> scan 'test'
ROW                                              COLUMN+CELL
 row1                                            column=cf:a, timestamp=1301984853863, value=value2
==> value2 ==> OK (the last one)
hbase(main):007:0> get 'test', 'row1'
COLUMN                                           CELL
 cf:a                                            timestamp=1301984853863, value=value2
1 row(s) in 0.1350 seconds
==> value2 ==> OK (the last one)
hbase(main):009:0> get 'test', 'row1',  { TIMERANGE => [0, 3000000000000]}
COLUMN                                           CELL
 cf:a                                            timestamp=1301984853863, value=value2
1 row(s) in 0.0260 seconds
==> I would have expected a list of values, namely value1 and value2, because they both
map the given timerange predicate.

Or maybe I missunderstood what we were talking about?


> Get cells via shell with a time range predicate
> -----------------------------------------------
>
>                 Key: HBASE-3729
>                 URL: https://issues.apache.org/jira/browse/HBASE-3729
>             Project: HBase
>          Issue Type: New Feature
>          Components: shell
>            Reporter: Eric Charles
>            Assignee: Ted Yu
>         Attachments: 3729-v2.txt, 3729.txt
>
>
> HBase shell allows to specify a timestamp to get a value
> - get 't1', 'r1', {COLUMN => 'c1', TIMESTAMP => ts1}
> If you don't give the exact timestamp, you get nothing... so it's difficult to get the
cell previous versions.
> It would be fine to have a "time range" predicate based get.
> The shell syntax could be (depending on technical feasibility)
> - get 't1', 'r1', {COLUMN => 'c1', TIMERANGE => (start_timestamp, end_timestamp)}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message