Hello
Writing Columnstore DataUnlike other columnstore implementations, MemSQL supports very fast, small-batch writes (such as single row inserts) directly into columnstore tables. This is implemented by storing newly written rows in a row-oriented skiplist before flushing them to the column-oriented format. This is all handled automatically behind the scenes, and rows are visible to reads as soon as they are committed to the row-oriented skiplist.(Columnstore · SingleStore Documentation)
According to the above,
Is data stored in memory before it is flushed back up to snapshots and logs?
Thanks.