Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB