The Ultimate Guide to High Availability with MariaDB

Maximum number of columns for MariaDB ColumnStore

When I tried to create a ColumnStore table which has 2310 columns, it returned "Error Code: 1117. Table definition is too large".

It looks like that the maximum number of columns for MariaDB ColumnStore may be 2201.

Why is this number? Can I change it ?

Answer Answered by Roman Nozdrin in this comment.

Unfortunately this limitation is imposed by the format that MariaDB server uses to describe a table. As of 10.9 the format doesn't allow more then 2 000 columns rouglhy speaking(the actual number depends on a number of factors).

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.