[
https://issues.apache.org/jira/browse/HBASE-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13015745#comment-13015745
]
Eric Charles commented on HBASE-3729:
-------------------------------------
Hi Ted,
Tks a lot for this!
I applied the patch to the scripts of 0.90-1, but I think the scripts have have
evolved in trunk (for example, I have no get.rb in 0.90-1.
I will try a bit later tomorrow the trunk with the TIMERANGE option to see if
it returns more than 1 cell (in your example, only one cell is returned).
Btw, does TIMERANGE => [ts1, ts2], VERSIONS => 4 limit the ouput to 4?
It would be useful to add the description when you type "get help" (also on the
http://wiki.apache.org/hadoop/Hbase/Shell)
hbase> get 't1', 'r1'
hbase> get 't1', 'r1', {COLUMN => 'c1'}
hbase> get 't1', 'r1', {COLUMN => ['c1', 'c2', 'c3']}
hbase> get 't1', 'r1', {COLUMN => 'c1', TIMESTAMP => ts1}
hbase> get 't1', 'r1', {COLUMN => 'c1', TIMESTAMP => ts1, VERSIONS => 4}
****** hbase> get 't1', 'r1', {COLUMN => 'c1', TIMERANGE => [ts1, ts2],
VERSIONS => 4}
hbase> get 't1', 'r1', 'c1'
hbase> get 't1', 'r1', 'c1', 'c2'
hbase> get 't1', 'r1', ['c1', 'c2']
> 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.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