You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cassandra.apache.org by Gaurav Agarwal <ga...@gmail.com> on 2024/02/22 05:47:25 UTC

Table name length limit in Cassandra

Hi team,

Currently Cassandra has a table name length limit of 48 characters. If I
understand correctly, it was made due to the fact that filename can not be
more than 255 characters in windows. However, Linux supports up to 4096
bytes of file name.

Given my Cassandra nodes are on Linux systems, can I increase the limit
from 48 characters to 64 characters? Will there be any performance issues
due to increasing the limit?

Thanks
Gaurav

Re: Table name length limit in Cassandra

Posted by Gaurav Agarwal <ga...@gmail.com>.

Thanks Bowen, good to know regarding performance issues. I am using a Java
client and will go ahead and check for any interoperability issues.

Regards!

On Thu, Feb 22, 2024 at 7:01 AM Bowen Song via dev <de...@cassandra.apache.org>
wrote:

> Hi Gaurav,
>
> I would be less worried about performance issues than interoperability
> issues. Other tools/client libraries do not expect this, and may cause
> them to behave unexpectedly (e.g. truncating/crashing/...).
>
> If you can, try get rid of common prefix/suffix, and use abbreviations
> where possible. You shouldn't have thousands of tables (and yes, there's
> performance issue with that), so the table name length limit really
> shouldn't be an issue.
>
> Best,
> Bowen
>
> On 22/02/2024 05:47, Gaurav Agarwal wrote:
> > Hi team,
> >
> > Currently Cassandra has a table name length limit of 48 characters. If
> > I understand correctly, it was made due to the fact that filename can
> > not be more than 255 characters in windows. However, Linux supports up
> > to 4096 bytes of file name.
> >
> > Given my Cassandra nodes are on Linux systems, can I increase the
> > limit from 48 characters to 64 characters? Will there be any
> > performance issues due to increasing the limit?
> >
> > Thanks
> > Gaurav
>

Re: Table name length limit in Cassandra

Posted by Bowen Song via dev <de...@cassandra.apache.org>.

Hi Gaurav,

I would be less worried about performance issues than interoperability 
issues. Other tools/client libraries do not expect this, and may cause 
them to behave unexpectedly (e.g. truncating/crashing/...).

If you can, try get rid of common prefix/suffix, and use abbreviations 
where possible. You shouldn't have thousands of tables (and yes, there's 
performance issue with that), so the table name length limit really 
shouldn't be an issue.

Best,
Bowen

On 22/02/2024 05:47, Gaurav Agarwal wrote:
> Hi team,
>
> Currently Cassandra has a table name length limit of 48 characters. If 
> I understand correctly, it was made due to the fact that filename can 
> not be more than 255 characters in windows. However, Linux supports up 
> to 4096 bytes of file name.
>
> Given my Cassandra nodes are on Linux systems, can I increase the 
> limit from 48 characters to 64 characters? Will there be any 
> performance issues due to increasing the limit?
>
> Thanks
> Gaurav