Disabling compression in columnstore table

Help
1

Hi All,

Is there a command/keyword to explicitly disable compression while creating a columnstore table .?

Thanks,
Faijaz

2

To help answer this question, what version of SingleStore are you running? Also, can you tell me more as to why you need this function? Is this to save on CPU or for greater speed?

3

Hi @wfaulkner ,
I am using singlestore 7.6 version .
We have a requirement to do load testing for 2TB volume of data. But current compression level of this table is ~90% and data volume is reduced to 50GB . So I was checking if we can load without compression I can easily get 2TB volume of data in singlestore and proceed with load testing.

4

Here is the answer that I got:
There’s no way to completely turn off columnstore compression. There are some ways to control encodings but they are undocumented. You’ll have to go through support to adjust those. See the documentation for more detail on the above.

5

Hi wfaulkner,

I’m interested in Ambassador Progam, Plz let me know the process.

Regards, Sam

1 Like