You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Rong-en Fan <gr...@gmail.com> on 2008/05/20 11:49:42 UTC

length of row key and column name

Hi,

I know that we can have length limit for the cell when creating
a table. But I'm not sure if there are any lengh limit of the  row
key and the column name?

Thanks,
Rong-En Fan

Re: length of row key and column name

Posted by stack <st...@duboce.net>.
I can't cite a use-case Rong-en but I'd bet someone will need it, sometime.
St.Ack

Rong-en Fan wrote:
> On Tue, May 20, 2008 at 10:35 PM, Jim Kellerman <ji...@powerset.com> wrote:
>   
>> No, there is no way to specify the maximum length of a row key or a column name.
>>     
>
> ok. Speaking of length limit, what's the rationale behind the limit on cell?
> Any performance reason or just a limit for convenience?
>
> Thanks,
> Rong-En fan
>
>   
>> ---
>> Jim Kellerman, Senior Engineer; Powerset
>>
>>
>>     
>>> -----Original Message-----
>>> From: Rong-en Fan [mailto:grafan@gmail.com]
>>> Sent: Tuesday, May 20, 2008 2:50 AM
>>> To: hbase-user@hadoop.apache.org
>>> Subject: length of row key and column name
>>>
>>> Hi,
>>>
>>> I know that we can have length limit for the cell when
>>> creating a table. But I'm not sure if there are any lengh
>>> limit of the  row key and the column name?
>>>
>>> Thanks,
>>> Rong-En Fan
>>>
>>> No virus found in this incoming message.
>>> Checked by AVG.
>>> Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release
>>> Date: 5/19/2008 7:44 AM
>>>
>>>       
>> No virus found in this outgoing message.
>> Checked by AVG.
>> Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release Date: 5/19/2008 7:44 AM
>>
>>

RE: length of row key and column name

Posted by Jim Kellerman <ji...@powerset.com>.
Actually, the length limit on a cell is not enforced anywhere. I suppose it was put there because someone thought that it might be useful at some point in time. For practical purposes, a row (including row and column keys and values) should be less than the maximum region size (which is configurable and defaults to 256MB)

---
Jim Kellerman, Senior Engineer; Powerset


> -----Original Message-----
> From: Rong-en Fan [mailto:grafan@gmail.com]
> Sent: Tuesday, May 20, 2008 8:04 AM
> To: hbase-user@hadoop.apache.org
> Subject: Re: length of row key and column name
>
> On Tue, May 20, 2008 at 10:35 PM, Jim Kellerman
> <ji...@powerset.com> wrote:
> > No, there is no way to specify the maximum length of a row
> key or a column name.
>
> ok. Speaking of length limit, what's the rationale behind the
> limit on cell?
> Any performance reason or just a limit for convenience?
>
> Thanks,
> Rong-En fan
>
> > ---
> > Jim Kellerman, Senior Engineer; Powerset
> >
> >
> >> -----Original Message-----
> >> From: Rong-en Fan [mailto:grafan@gmail.com]
> >> Sent: Tuesday, May 20, 2008 2:50 AM
> >> To: hbase-user@hadoop.apache.org
> >> Subject: length of row key and column name
> >>
> >> Hi,
> >>
> >> I know that we can have length limit for the cell when creating a
> >> table. But I'm not sure if there are any lengh limit of
> the  row key
> >> and the column name?
> >>
> >> Thanks,
> >> Rong-En Fan
> >>
> >> No virus found in this incoming message.
> >> Checked by AVG.
> >> Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release
> >> Date: 5/19/2008 7:44 AM
> >>
> > No virus found in this outgoing message.
> > Checked by AVG.
> > Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release Date:
> > 5/19/2008 7:44 AM
> >
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release
> Date: 5/19/2008 7:44 AM
>
No virus found in this outgoing message.
Checked by AVG.
Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release Date: 5/19/2008 7:44 AM

Re: length of row key and column name

Posted by Rong-en Fan <gr...@gmail.com>.
On Tue, May 20, 2008 at 10:35 PM, Jim Kellerman <ji...@powerset.com> wrote:
> No, there is no way to specify the maximum length of a row key or a column name.

ok. Speaking of length limit, what's the rationale behind the limit on cell?
Any performance reason or just a limit for convenience?

Thanks,
Rong-En fan

> ---
> Jim Kellerman, Senior Engineer; Powerset
>
>
>> -----Original Message-----
>> From: Rong-en Fan [mailto:grafan@gmail.com]
>> Sent: Tuesday, May 20, 2008 2:50 AM
>> To: hbase-user@hadoop.apache.org
>> Subject: length of row key and column name
>>
>> Hi,
>>
>> I know that we can have length limit for the cell when
>> creating a table. But I'm not sure if there are any lengh
>> limit of the  row key and the column name?
>>
>> Thanks,
>> Rong-En Fan
>>
>> No virus found in this incoming message.
>> Checked by AVG.
>> Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release
>> Date: 5/19/2008 7:44 AM
>>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release Date: 5/19/2008 7:44 AM
>

RE: length of row key and column name

Posted by Jim Kellerman <ji...@powerset.com>.
No, there is no way to specify the maximum length of a row key or a column name.

---
Jim Kellerman, Senior Engineer; Powerset


> -----Original Message-----
> From: Rong-en Fan [mailto:grafan@gmail.com]
> Sent: Tuesday, May 20, 2008 2:50 AM
> To: hbase-user@hadoop.apache.org
> Subject: length of row key and column name
>
> Hi,
>
> I know that we can have length limit for the cell when
> creating a table. But I'm not sure if there are any lengh
> limit of the  row key and the column name?
>
> Thanks,
> Rong-En Fan
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release
> Date: 5/19/2008 7:44 AM
>
No virus found in this outgoing message.
Checked by AVG.
Version: 8.0.100 / Virus Database: 269.23.21/1454 - Release Date: 5/19/2008 7:44 AM