|
|
-
Is there a way to view multiple versions of a cell in the HBase shell?
Jonathan Natkins 2013-03-07, 17:08
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.comoffice: 1.415.496.9424 x208 cell: 1.609.577.1600 twitter: @nattyice < http://www.twitter.com/nattyice>
+
Jonathan Natkins 2013-03-07, 17:08
-
Re: Is there a way to view multiple versions of a cell in the HBase shell?
Dhaval Shah 2013-03-07, 17:22
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.comoffice: 1.415.496.9424 x208 cell: 1.609.577.1600 twitter: @nattyice < http://www.twitter.com/nattyice>
+
Dhaval Shah 2013-03-07, 17:22
-
Re: Is there a way to view multiple versions of a cell in the HBase shell?
Himanshu Vashishtha 2013-03-07, 17:23
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>
+
Himanshu Vashishtha 2013-03-07, 17:23
-
Re: Is there a way to view multiple versions of a cell in the HBase shell?
Jonathan Natkins 2013-03-07, 17:33
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.comoffice: 1.415.496.9424 x208 cell: 1.609.577.1600 twitter: @nattyice < http://www.twitter.com/nattyice>
+
Jonathan Natkins 2013-03-07, 17:33
-
Re: Is there a way to view multiple versions of a cell in the HBase shell?
Jonathan Natkins 2013-03-07, 17:36
Filed https://issues.apache.org/jira/browse/HBASE-8026On Thu, Mar 7, 2013 at 9:33 AM, Jonathan Natkins <[EMAIL PROTECTED]> wrote: > 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>> -- http://www.wibidata.comoffice: 1.415.496.9424 x208 cell: 1.609.577.1600 twitter: @nattyice < http://www.twitter.com/nattyice>
+
Jonathan Natkins 2013-03-07, 17:36
-
Re: Is there a way to view multiple versions of a cell in the HBase shell?
Jean-Daniel Cryans 2013-03-07, 17:21
Hey Natty, Have you tried setting VERSIONS? J-D On Thu, Mar 7, 2013 at 9:08 AM, Jonathan Natkins <[EMAIL PROTECTED]> wrote: > 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>
+
Jean-Daniel Cryans 2013-03-07, 17:21
|
|