accumulo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Loss <>
Subject Re: scan fixed range from shell
Date Thu, 29 Oct 2015 14:52:25 GMT
The -b and -e options specify the row portion of the key, and they are inclusive. However,
1_abc > 1_ (and the same is true for all of your other 1_ example keys), so none are returned.
If you have multiple entries for the same row (any of [column family, column qualifier, column
visibility, timestamp] differ but the row is the same), then specifying the same value for
-b and -e will give you all of those entries. In your case, you need to do what you said last,
and pick a character lexicographically higher than the one you want. something like -b 1_
-e 1~ would work. 

> On Oct 29, 2015, at 10:41 AM, z11373 <> wrote:
> Hi,
> Let say I have table T1 with following keys:
> 1_abc
> 1_def
> 1_xyz
> 2_xxx
> 2_yyy
> 3_a
> 3_ab
> ...
> I want to scan and only returns data with prefix '1_', so I run "scan -t T1
> -b 1_ -e 1_", but it returns no data. However, running "scan -t T1 -b 1_ -e
> 2" will return what I want. I thought that -e should include that value
> (inclusive)?
> How can I scan fixed range from shell like in this example above? Do I just
> need to pick character which is lexicographically sorted higher than the one
> I want?
> Thanks,
> Z
> --
> View this message in context:
> Sent from the Users mailing list archive at

View raw message