Does it use dictionary encoding?
MemSQL has several different kinds of encoding (compression) for columnstore tables, including dictionary encoding. It doesn’t compress individual strings. The bottom line is that compression in the range of 5-to-1 up to 10-to-1 is typical for data warehouse fact tables or other large tables of business events.