Details
-
New Feature
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
Copied from the thread:
https://mariadb.com/kb/en/mariadb/mariadb-columnstore-can-we-extend-the-max-length-of-the-data-types-varchar-/
I think my use case is very common. We have a 1500 columns table where each row stores all the data of a single transaction. In order to create the table in the columnstore engine, we kept getting the error: "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535"
The row size (and max number of columns of 4096) is a limit enforced by the mariadb server derived from the original mysql code base.
Two options:
1. Remove the row size limitation of 65535 so that we can create more columns to accommodate the content of Text/Blob data type. Frankly, I don't like this option for I have to split the content before inserting and concatenate them together before returning results.
2. Set high priority of supporting Text (MCOL-267) and Blob (MCOL-356) data types.
I set this issue as major priority for it will impact on the marketing of MariaDB ColumnStore. Thanks for your great support.