Hello,

I have a simple table where the data looks like this,

key,value
2011-01-01.foo,data01
2011-01-02.foo,data02
2011-01-03.foo,data03
2011-01-04.foo,data04
2011-01-05.foo,data05
2011-01-05.foo,data06

Does anyone have any example code to perform a range query like, get all
values for keys which has a range from [2011-01-03.foo to 2011-01-05.foo]?
The expected answer should be:

data03
date04
data05

--
--- Get your facts first, then you can distort them as you please.--

Hi there-

Check out the Hbase book...

http://hbase.apache.org/book.html#scan
On 10/5/11 3:29 AM, "Rita" <[EMAIL PROTECTED]> wrote:

>Hello,
>
>I have a simple table where the data looks like this,
>
>key,value
>2011-01-01.foo,data01
>2011-01-02.foo,data02
>2011-01-03.foo,data03
>2011-01-04.foo,data04
>2011-01-05.foo,data05
>2011-01-05.foo,data06
>
>Does anyone have any example code to perform a range query like, get all
>values for keys which has a range from [2011-01-03.foo to 2011-01-05.foo]?
>The expected answer should be:
>
>data03
>date04
>data05
>
>
>
>
>
>--
>--- Get your facts first, then you can distort them as you please.--

Thanks. This worked like a charm.

Is it common to use regex for timeseries or is there a more elegant way of
handling it?
On Wed, Oct 5, 2011 at 8:39 AM, Doug Meil <[EMAIL PROTECTED]>wrote:

>
> Hi there-
>
> Check out the Hbase book...
>
> http://hbase.apache.org/book.html#scan
>
>
>
>
> On 10/5/11 3:29 AM, "Rita" <[EMAIL PROTECTED]> wrote:
>
> >Hello,
> >
> >I have a simple table where the data looks like this,
> >
> >key,value
> >2011-01-01.foo,data01
> >2011-01-02.foo,data02
> >2011-01-03.foo,data03
> >2011-01-04.foo,data04
> >2011-01-05.foo,data05
> >2011-01-05.foo,data06
> >
> >Does anyone have any example code to perform a range query like, get all
> >values for keys which has a range from [2011-01-03.foo to 2011-01-05.foo]?
> >The expected answer should be:
> >
> >data03
> >date04
> >data05
> >
> >
> >
> >
> >
> >--
> >--- Get your facts first, then you can distort them as you please.--
>
>
--
--- Get your facts first, then you can distort them as you please.--

Regex is going to be more expensive than checking bytes or comparing longs.   But I wouldn't worry about it at least till you finger the regexing as perf prob

On Oct 5, 2011, at 15:42, Rita <[EMAIL PROTECTED]> wrote:

> Thanks. This worked like a charm.
>
> Is it common to use regex for timeseries or is there a more elegant way of
> handling it?
>
>
> On Wed, Oct 5, 2011 at 8:39 AM, Doug Meil <[EMAIL PROTECTED]>wrote:
>
>>
>> Hi there-
>>
>> Check out the Hbase book...
>>
>> http://hbase.apache.org/book.html#scan
>>
>>
>>
>>
>> On 10/5/11 3:29 AM, "Rita" <[EMAIL PROTECTED]> wrote:
>>
>>> Hello,
>>>
>>> I have a simple table where the data looks like this,
>>>
>>> key,value
>>> 2011-01-01.foo,data01
>>> 2011-01-02.foo,data02
>>> 2011-01-03.foo,data03
>>> 2011-01-04.foo,data04
>>> 2011-01-05.foo,data05
>>> 2011-01-05.foo,data06
>>>
>>> Does anyone have any example code to perform a range query like, get all
>>> values for keys which has a range from [2011-01-03.foo to 2011-01-05.foo]?
>>> The expected answer should be:
>>>
>>> data03
>>> date04
>>> data05
>>>
>>>
>>>
>>>
>>>
>>> --
>>> --- Get your facts first, then you can distort them as you please.--
>>
>>
>
>
> --
> --- Get your facts first, then you can distort them as you please.--