Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> Is there a way to view multiple versions of a cell in the HBase shell?


+
Jonathan Natkins 2013-03-07, 17:08
+
Dhaval Shah 2013-03-07, 17:22
+
Himanshu Vashishtha 2013-03-07, 17:23
Copy link to this message
-
Re: Is there a way to view multiple versions of a cell in the HBase shell?
Ah, cool, that worked just fine. Missed this, because the scan
documentation doesn't contain any references to VERSION:

hbase(main):046: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, TIMESTAMP, MAXLENGTH,
or COLUMNS, CACHE
On Thu, Mar 7, 2013 at 9:23 AM, Himanshu Vashishtha <[EMAIL PROTECTED]
> wrote:

> Hey Natty,
>
> hbase(main):020:0> get 't','r', { COLUMN => 'f', VERSIONS => 2 }
> COLUMN                                     CELL
>  f:l                                       timestamp=1362676782345,
> value=value2
>  f:l                                       timestamp=1362676779492,
> value=value1
> 2 row(s) in 0.0120 seconds
>
> :)
>
> On Thu, Mar 7, 2013 at 9:22 AM, Dhaval Shah <[EMAIL PROTECTED]>
> wrote:
> > I think you can. Try specifying the following "VERSIONS => 4"|
> >
> > Its also documented in the HBase shell documentation for Get (and I am
> assuming the same would apply for scans)|
> >
> > get       Get row or cell contents; pass table name, row, and optionally
> a dictionary of column(s), timestamp and versions.  Examples: 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}
> >
> > Regards,
> > Dhaval
> >
> >
> > ________________________________
> >  From: Jonathan Natkins <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Sent: Thursday, 7 March 2013 12:08 PM
> > Subject: Is there a way to view multiple versions of a cell in the HBase
> shell?
> >
> > It seems that the answer is no, but I just wanted to make sure I didn't
> > miss something. As far as I can tell, scanning a column on a time range
> > returns just the most recent value within that time range, rather than
> all
> > the values in the range.
> >
> > Thanks,
> > Natty
> >
> > --
> > http://www.wibidata.com
> > office: 1.415.496.9424 x208
> > cell: 1.609.577.1600
> > twitter: @nattyice <http://www.twitter.com/nattyice>
>

--
http://www.wibidata.com
office: 1.415.496.9424 x208
cell: 1.609.577.1600
twitter: @nattyice <http://www.twitter.com/nattyice>
+
Jonathan Natkins 2013-03-07, 17:36
+
Jean-Daniel Cryans 2013-03-07, 17:21