Encoding field for ' information_schema.columnar_segments'

Off-Topic
1

I have a question while checking ‘information_schema.columnar_segments’.

I think the encoding of the column keeps changing.
Please explain about this.

image

image
image1046×533 17 KB

Thanks.

2

MemSQL will make a decision on the best compression scheme to use based on the data present in each segment (~1 million rows of data) for a given column. So its not unusual to see multiple encodings used for different segments of the table.

It may help to read some of the overview sections about how the MemSQL columnstore works: Columnstore · SingleStore Documentation to get a feel for how the data organized.