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).
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.
