Comments - ColumnStore Data Types
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.
I believe the big problem of not having TEXT/BLOBs data types is that the amount of columns supported by the engine columnstore is very limited, around 400 columns if most of them are structured data. Although that is reasonable in OLTP environments, it is not acceptable in OLAP .
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 (IP addresses, messages sent/received, subscriber data,...). Many of the columns of the table are TINYTEXT. In order to create the table in the columnstore engine, we changed all those columns to varchar(256), but it wasn't possible because we kept getting the error:
"Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535".
The only way to create the table was to reduce the amount of columns to less than 350. We can't loose that many columns in production environments.
That's the reason why I believe MCOL-267 and MCOL-356 should have a higher priority.
Hi José,
MariaDB ColumnStore 1.1 has implemented BLOB/TEXT data types. I hope this addresses your concerns.