question versioning question in hbase in Support Questions

versioning question in hbase

aliyesami — Tue, 26 Feb 2019 00:05:40 GMT

I can select a particular version from a table , but how can I select a range of versions ? e.g say I want to select all the rows from timestamp 1551108073557 to 1551108018724 ?

hbase(main):005:0> scan 'PERSON',{NAME => 'student',VERSIONS => 5}
ROW COLUMN+CELL
r1 column=student:student_name, timestamp=1551108086986, value=John
r1 column=student:student_name, timestamp=1551108073557, value=Mary
r1 column=student:student_name, timestamp=1551108037609, value=Nancy
r1 column=student:student_name, timestamp=1551108018724, value=Ram
r1 column=student:student_name, timestamp=1551108002231, value=Sam
1 row(s) in 0.0190 seconds

hbase(main):006:0>
hbase(main):007:0*
hbase(main):008:0* get 'PERSON','r1',{COLUMN => 'student', TIMESTAMP => 1551108018724}
COLUMN CELL
student:student_name timestamp=1551108018724, value=Ram

Re: versioning question in hbase

elserj — Tue, 26 Feb 2019 00:47:56 GMT

hbase(main):001:0> help 'scan'
Scan a table; pass table name and optionally a dictionary of scanner
specifications.  Scanner specifications may include one or more of:
TIMERANGE, FILTER, LIMIT, STARTROW, STOPROW, ROWPREFIXFILTER, TIMESTAMP,
MAXLENGTH or COLUMNS, CACHE or RAW, VERSIONS, ALL_METRICS or METRICS

...

Some examples:

  ...
  hbase> scan 't1', {COLUMNS => 'c1', TIMERANGE => [1303668804000, 1303668904000]}

Re: versioning question in hbase

aliyesami — Tue, 26 Feb 2019 00:52:39 GMT

hi Josh how can I do it via 'get' command ? since we will be using java to get these rows

Re: versioning question in hbase

elserj — Tue, 26 Feb 2019 01:01:44 GMT

Use a Scanner. You can't use Gets, as a Get requires you to know a rowKey.

Re: versioning question in hbase

aliyesami — Tue, 26 Feb 2019 01:05:30 GMT

and can "scan" command be called from a java code ?