from: https://mariadb.com/kb/en/mariadb/mariadb-columnstore-can-we-extend-the-max-length-of-the-data-types-varchar-/

Our case is described as follows: We have a very large table required to support many years' transactions. We don't want to partition the table according to specific columns. So we plan to keep 6 months' records in row store and migrate older history data to column store. However, we are blocked by the data type issues, such as the length limitation of varchar and varbinary, not supporting text and blob.

We don't want to keep the text or blob data in row store for the count of records is very large, such as 1 billion. In addition the join speed is not acceptable for complex queries. Actually, we only need get the value of text or blob after queries.

By the way, can you provide such a feature to support mixed storage for the same table? In other words, the system can migrate older data to column store automatically. Right now, I have to migrate the old records from row store to column store online. Please give me ideas for my case. Thank you very much.