Search code examples
databasesinglestore

What is the maximum number of columns in MemSQL?


There seems to be the same 4096 column limit MySQL has. Is there any way to override this and create larger tables, eg. in columnstore format?


Solution

  • The column limit in MemSQL is currently 4096, and it is not tunable. The best way to get around it is to use a JSON column (http://docs.memsql.com/latest/json/json/).