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